DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on ORG_FREIGHT

Line 1080: -- validate ship_via_lookup_code against ORG_FREIGHT

1076: RAISE;
1077: END bill_to_location_id;
1078:
1079: -------------------------------------------------------------------------
1080: -- validate ship_via_lookup_code against ORG_FREIGHT
1081: -------------------------------------------------------------------------
1082: PROCEDURE ship_via_lookup_code(
1083: p_id_tbl IN po_tbl_number,
1084: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,

Line 1129: FROM org_freight ofr

1125: FROM DUAL
1126: WHERE p_ship_via_lookup_code_tbl(i) IS NOT NULL
1127: AND NOT EXISTS(
1128: SELECT 1
1129: FROM org_freight ofr
1130: WHERE p_ship_via_lookup_code_tbl(i) = ofr.freight_code
1131: AND NVL(ofr.disable_date, SYSDATE + 1) > SYSDATE
1132: AND ofr.organization_id = p_inventory_org_id);
1133: