APPS.PO_ITEMS_SV dependencies on MTL_ITEM_REVISIONS

Line 99: mtl_item_revisions mir

95: */
96: SELECT MAX('Y')
97: INTO X_item_valid
98: FROM mtl_system_items msi,
99: mtl_item_revisions mir
100: WHERE mir.organization_id = X_master_ship_org_id
101: AND mir.revision = X_item_revision
102: AND mir.inventory_item_id = X_item_id
103: AND msi.inventory_item_id = X_item_id

Line 562: FROM mtl_item_revisions mir

558: IF (X_item_revision is NOT NULL) THEN
559:
560: SELECT MAX('Y')
561: INTO X_revision_is_valid
562: FROM mtl_item_revisions mir
563: WHERE mir.organization_id = X_destination_org_id
564: AND mir.revision = X_item_revision
565: AND mir.inventory_item_id = X_item_id;
566:

Line 719: FROM mtl_item_revisions MIR,

715: INTO l_dummy
716: FROM DUAL
717: WHERE EXISTS
718: (SELECT MIR.revision
719: FROM mtl_item_revisions MIR,
720: org_organization_definitions OOD
721: WHERE OOD.set_of_books_id = p_sob_id
722: AND SYSDATE < NVL(OOD.disable_date, SYSDATE + 1)
723: AND MIR.organization_id = OOD.organization_id

Line 754: mtl_item_revisions MIR,

750: SELECT l_key,
751: MIR.revision,
752: count(*)
753: FROM po_line_locations_all PLL,
754: mtl_item_revisions MIR,
755: org_organization_definitions OOD
756: WHERE PLL.po_line_id = p_po_line_id
757: AND NVL(PLL.cancel_flag, 'N') = 'N'
758: AND MIR.inventory_item_id = p_item_id