DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on RCV_SUPPLY

Line 5790: FROM mtl_item_revisions miv, rcv_supply rs

5786: OPEN x_revs FOR
5787: SELECT DISTINCT miv.revision
5788: , miv.effectivity_date
5789: , NVL(miv.description, '')
5790: FROM mtl_item_revisions miv, rcv_supply rs
5791: WHERE miv.organization_id = p_organization_id
5792: AND miv.inventory_item_id = p_inventory_item_id
5793: AND rs.shipment_header_id(+) = p_shipment_header_id
5794: AND (rs.shipment_header_id IS NULL

Line 5817: FROM mtl_item_revisions miv, rcv_supply rs

5813: OPEN x_revs FOR
5814: SELECT DISTINCT miv.revision
5815: , miv.effectivity_date
5816: , NVL(miv.description, '')
5817: FROM mtl_item_revisions miv, rcv_supply rs
5818: WHERE miv.organization_id = p_organization_id
5819: AND miv.inventory_item_id = p_inventory_item_id
5820: AND rs.shipment_header_id(+) = p_shipment_header_id
5821: AND (rs.shipment_header_id IS NULL

Line 5839: FROM mtl_item_revisions miv, rcv_supply rs

5835: OPEN x_revs FOR
5836: SELECT DISTINCT miv.revision
5837: , miv.effectivity_date
5838: , NVL(miv.description, '')
5839: FROM mtl_item_revisions miv, rcv_supply rs
5840: WHERE miv.organization_id = p_organization_id
5841: AND miv.inventory_item_id = p_inventory_item_id
5842: AND rs.po_header_id(+) = p_po_header_id
5843: AND (rs.po_header_id IS NULL