DBA Data[Home] [Help]

APPS.GMPMPACT dependencies on PO_PO_SUPPLY_VIEW

Line 585: PO_PO_SUPPLY_VIEW po

581: SELECT po.po_number
582: FROM MTL_PARAMETERS mtl,
583: MTL_SYSTEM_ITEMS mitem,
584: -- IC_ITEM_MST ic,
585: PO_PO_SUPPLY_VIEW po
586: WHERE po.item_id = mitem.inventory_item_id
587: AND po.to_organization_id = mitem.organization_id
588: -- AND mitem.segment1 = ic.item_no
589: AND mtl.organization_id = po.to_organization_id

Line 926: ' po_po_supply_view po, mtl_system_items mitem '||

922: ' NULL)) trans_qty2, '||
923: ' po.po_line_location_id line_id, mtl.organization_code inv_org_code '||
924: ' FROM MTL_PARAMETERS mtl, '||
925: ' hr_organization_units hou, '||
926: ' po_po_supply_view po, mtl_system_items mitem '||
927: ' WHERE po.item_id = TO_CHAR(:item_id) '||
928: ' AND po.item_id = mitem.inventory_item_id '||
929: ' AND po.to_organization_id = mitem.organization_id '||
930: ' AND mtl.organization_id = po.to_organization_id '||

Line 1528: PO_PO_SUPPLY_VIEW po

1524: FROM MTL_PARAMETERS mtl,
1525: PO_VENDORS pv,
1526: MTL_SYSTEM_ITEMS mitem,
1527: -- IC_ITEM_MST ic,
1528: PO_PO_SUPPLY_VIEW po
1529: WHERE po.item_id = mitem.inventory_item_id
1530: AND pv.vendor_id = po.vendor_id
1531: AND po.to_organization_id = mitem.organization_id
1532: -- AND mitem.segment1 = ic.item_no