APPS.GMPMPACT dependencies on MTL_DEMAND_OMOE

Line 826: ' mtl_demand_omoe mtl, '||

822: ' NULL '||
823: ' )) trans_qty2, '||
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, '||

Line 859: ' mtl_demand_omoe dem'||

855: ' and NOT EXISTS '||
856: ' (SELECT 1 '||
857: ' FROM so_lines_all sl, '||
858: ' so_lines_all slp, '||
859: ' mtl_demand_omoe dem'||
860: ' WHERE '||
861: ' slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)'||
862: ' and to_number(dem.demand_source_line) = sl.line_id(+) '||
863: ' and dem.demand_source_type in (2,8)'||

Line 1643: mtl_demand_omoe mtl

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
1645: AND ol.line_id = mtl.demand_id
1646: AND oh.sold_to_org_id = sold_to_org.organization_id(+)
1647: AND mtl.demand_source_header_id = G_doc_id

Line 1660: mtl_demand_omoe mtl

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
1662: AND ol.line_id = mtl.demand_id
1663: AND oh.sold_to_org_id = sold_to_org.organization_id(+)
1664: AND mtl.demand_source_header_id = G_doc_id