APPS.GMPMPACT dependencies on MTL_DEMAND_OMOE

Line 828: ' mtl_demand_omoe mtl, '||

824: ' NULL '||
825: ' )) trans_qty2, '||
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, '||

Line 861: ' mtl_demand_omoe dem'||

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

Line 1659: mtl_demand_omoe mtl

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

Line 1678: mtl_demand_omoe mtl

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