APPS.PO_VAL_SHIPMENTS2 dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 647: -- validate ship_to_organization_id against org_organization_definitions

643: x_result_type := po_validations.c_result_type_failure;
644: END IF;
645:
646: -- If item_id is null, and ship_to_organization_id is not null,
647: -- validate ship_to_organization_id against org_organization_definitions
648: FORALL i IN 1 .. p_id_tbl.COUNT
649: INSERT INTO po_validation_results_gt
650: (result_set_id,
651: result_type,

Line 675: FROM org_organization_definitions ood

671: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
672: AND p_item_id_tbl(i) IS NULL
673: AND NOT EXISTS(
674: SELECT 1
675: FROM org_organization_definitions ood
676: WHERE ood.organization_id = p_ship_to_organization_id_tbl(i)
677: AND SYSDATE < NVL(ood.disable_date, SYSDATE + 1)
678: AND ood.inventory_enabled_flag = 'Y');
679: