DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on OE_ORDER_HEADERS_ALL

Line 560: FROM oe_order_headers_all oh,

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

Line 573: FROM oe_order_headers_all oh,

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

Line 830: ' oe_order_headers_all hdr, '||

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

Line 1656: FROM oe_order_headers_all oh,

1652: CURSOR Cur_om_order_details IS
1653: --Modified to name from customer_number as per bug # 11068148
1654: SELECT DISTINCT substr(sold_to_org.name,1,40)
1655: --DISTINCT sold_to_org.customer_number
1656: FROM oe_order_headers_all oh,
1657: oe_order_lines_all ol,
1658: oe_sold_to_orgs_v sold_to_org,
1659: mtl_demand_omoe mtl
1660: WHERE oh.header_id = ol.header_id

Line 1675: FROM oe_order_headers_all oh,

1671: CURSOR Cur_excl_internal_omso_dtl IS
1672: --Modified to name from customer_number as per bug # 11068148
1673: SELECT DISTINCT substr(sold_to_org.name,1,40)
1674: -- DISTINCT sold_to_org.customer_number
1675: FROM oe_order_headers_all oh,
1676: oe_order_lines_all ol,
1677: oe_sold_to_orgs_v sold_to_org,
1678: mtl_demand_omoe mtl
1679: WHERE oh.header_id = ol.header_id