APPS.PO_VAL_SHIPMENTS2 dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1011: -- validate ship_to_organization_id against org_organization_definitions

1007: x_result_type := po_validations.c_result_type_failure;
1008: END IF;
1009:
1010: -- If item_id is null, and ship_to_organization_id is not null,
1011: -- validate ship_to_organization_id against org_organization_definitions
1012: FORALL i IN 1 .. p_id_tbl.COUNT
1013: INSERT INTO po_validation_results_gt
1014: (result_set_id,
1015: result_type,

Line 1039: FROM org_organization_definitions ood

1035: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
1036: AND p_item_id_tbl(i) IS NULL
1037: AND NOT EXISTS(
1038: SELECT 1
1039: FROM org_organization_definitions ood
1040: WHERE ood.organization_id = p_ship_to_organization_id_tbl(i)
1041: AND SYSDATE < NVL(ood.disable_date, SYSDATE + 1)
1042: AND ood.inventory_enabled_flag = 'Y');
1043: