APPS.PO_ITEMS_SV dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 578: FROM org_organization_definitions

574: IF (X_revision_is_valid is null) THEN
575:
576: SELECT organization_name
577: INTO X_destination_org_name
578: FROM org_organization_definitions
579: WHERE organization_id = X_destination_org_id;
580:
581: x_progress := '030';
582:

Line 696: org_organization_definitions OOD

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
700: AND MIR.inventory_item_id = p_item_id);

Line 732: org_organization_definitions OOD

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
736: AND OOD.set_of_books_id = p_sob_id