--
Query to check SO Quantities ordered for an item in a given date range.
select oha. attribute2, sum(ordered_quantity), sum(shipped_quantity)
from apps. oe_order_lines_all ola,
apps. oe_order_headers_all oha
where oha. attribute2 between '01-APR-14' and '08-APR-14' and oha. org_id = 82
and oha. attribute2 like '%APR%'
and oha. header_id = ola. header_id
and oha. orig_sys_document_ref not like 'RET%'
and ola. user_item_description like '110415HP1%'
and ola. ship_from_org_id = 95
group by oha. attribute2
order by oha. attribute2
select * from apps. mtl_onhand_quantities_detail where inventory_item_id = 4014 and organization_id = 95
select * from apps. mtl_system_items_b where segment1 like '110415HP%'
select * from apps. org_organization_definitions where organization_code = 'F40'
Query to check SO Quantities ordered for an item in a given date range.
select oha. attribute2, sum(ordered_quantity), sum(shipped_quantity)
from apps. oe_order_lines_all ola,
apps. oe_order_headers_all oha
where oha. attribute2 between '01-APR-14' and '08-APR-14' and oha. org_id = 82
and oha. attribute2 like '%APR%'
and oha. header_id = ola. header_id
and oha. orig_sys_document_ref not like 'RET%'
and ola. user_item_description like '110415HP1%'
and ola. ship_from_org_id = 95
group by oha. attribute2
order by oha. attribute2
select * from apps. mtl_onhand_quantities_detail where inventory_item_id = 4014 and organization_id = 95
select * from apps. mtl_system_items_b where segment1 like '110415HP%'
select * from apps. org_organization_definitions where organization_code = 'F40'
3 comments
Excellent and very cool idea and the subject at the top of magnificence and I am happy to comment on this topic through which we address the idea of positive re like this.
ReplyCRM Software in Denmark | CRM Solutions
Great Article Artificial Intelligence Projects
ReplyProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
Great Article Artificial Intelligence Projects
ReplyProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
Post a Comment