Tuesday, March 22, 2016

Query to check Sales order Quantities ordered for an item in a given date range.

--

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'

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...