APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on ORG_FREIGHT_CODE_VAL_V

Line 790: x_freight_code org_freight_code_val_v.freight_code%TYPE;

786: ===========================================================================*/
787: PROCEDURE validate_freight_carrier(
788: x_freight_carrier_record IN OUT NOCOPY rcv_shipment_line_sv.freight_carrier_record_type
789: ) IS
790: x_freight_code org_freight_code_val_v.freight_code%TYPE;
791: x_progress VARCHAR2(3);
792: x_error_status VARCHAR2(1);
793: BEGIN
794: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 798: FROM org_freight_code_val_v

794: x_error_status := rcv_error_pkg.g_ret_sts_error;
795:
796: SELECT NVL(MAX(freight_code), 'notfound')
797: INTO x_freight_code
798: FROM org_freight_code_val_v
799: WHERE freight_code = x_freight_carrier_record.freight_carrier_code
800: AND organization_id = NVL(x_freight_carrier_record.to_organization_id, organization_id);
801:
802: IF (x_freight_code = 'notfound') THEN