DBA Data[Home] [Help]

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 720: org_organization_definitions OOD

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

Line 755: org_organization_definitions OOD

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