DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on ORG_FREIGHT

Line 1070: -- validate ship_via_lookup_code against ORG_FREIGHT

1066: RAISE;
1067: END bill_to_location_id;
1068:
1069: -------------------------------------------------------------------------
1070: -- validate ship_via_lookup_code against ORG_FREIGHT
1071: -------------------------------------------------------------------------
1072: PROCEDURE ship_via_lookup_code(
1073: p_id_tbl IN po_tbl_number,
1074: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,

Line 1119: FROM org_freight ofr

1115: FROM DUAL
1116: WHERE p_ship_via_lookup_code_tbl(i) IS NOT NULL
1117: AND NOT EXISTS(
1118: SELECT 1
1119: FROM org_freight ofr
1120: WHERE p_ship_via_lookup_code_tbl(i) = ofr.freight_code
1121: AND NVL(ofr.disable_date, SYSDATE + 1) > SYSDATE
1122: AND ofr.organization_id = p_inventory_org_id);
1123: