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 695: FROM mtl_item_revisions MIR,

691: INTO l_dummy
692: FROM DUAL
693: WHERE EXISTS
694: (SELECT MIR.revision
695: FROM mtl_item_revisions MIR,
696: org_organization_definitions OOD
697: WHERE OOD.set_of_books_id = p_sob_id
698: AND SYSDATE < NVL(OOD.disable_date, SYSDATE + 1)
699: AND MIR.organization_id = OOD.organization_id

Line 731: mtl_item_revisions MIR,

727: SELECT l_key,
728: MIR.revision,
729: count(*)
730: FROM po_line_locations_all PLL,
731: mtl_item_revisions MIR,
732: org_organization_definitions OOD
733: WHERE PLL.po_line_id = p_po_line_id
734: AND NVL(PLL.cancel_flag, 'N') = 'N'
735: AND MIR.inventory_item_id = p_item_id