APPS.GMPMPACT dependencies on OE_ORDER_HEADERS_ALL

Line 558: FROM oe_order_headers_all oh,

554:
555: /*B4905079 - Changed the cursor to improve the performance*/
556: CURSOR Cur_omso_doc_no IS
557: SELECT DISTINCT oh.order_number
558: FROM oe_order_headers_all oh,
559: oe_order_lines_all ol
560: WHERE oh.header_id = ol.header_id
561: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
562: AND ol.open_flag = 'Y'

Line 571: FROM oe_order_headers_all oh,

567: -- Internal Sales Orders profile was set to Y.
568: /*B4905079 - Changed the cursor to improve the performance*/
569: CURSOR Cur_excl_internal_omso_doc_no IS
570: SELECT DISTINCT oh.order_number
571: FROM oe_order_headers_all oh,
572: oe_order_lines_all ol
573: WHERE oh.header_id = ol.header_id
574: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
575: AND ol.open_flag = 'Y'

Line 828: ' oe_order_headers_all hdr, '||

824: ' dtl.line_id line_id, org.organization_code inv_org_code '||
825: 'FROM '||
826: ' mtl_demand_omoe mtl, '||
827: ' mtl_system_items items, '||
828: ' oe_order_headers_all hdr, '||
829: ' oe_order_lines_all dtl, '||
830: ' hr_organization_units hou, '||
831: ' mtl_parameters org '||
832: ' WHERE '||

Line 1640: FROM oe_order_headers_all oh,

1636: AND po.req_line_id = G_tranline_id ;
1637:
1638: CURSOR Cur_om_order_details IS
1639: SELECT DISTINCT sold_to_org.customer_number
1640: FROM oe_order_headers_all oh,
1641: oe_order_lines_all ol,
1642: oe_sold_to_orgs_v sold_to_org,
1643: mtl_demand_omoe mtl
1644: WHERE oh.header_id = ol.header_id

Line 1657: FROM oe_order_headers_all oh,

1653: -- TKW B3865101 9/15/04 Added cursor for the case where Exclude
1654: -- Internal Sales Orders profile was set to Y.
1655: CURSOR Cur_excl_internal_omso_dtl IS
1656: SELECT DISTINCT sold_to_org.customer_number
1657: FROM oe_order_headers_all oh,
1658: oe_order_lines_all ol,
1659: oe_sold_to_orgs_v sold_to_org,
1660: mtl_demand_omoe mtl
1661: WHERE oh.header_id = ol.header_id