APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on ORG_FREIGHT

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

Line 809: FROM org_freight

805: END IF;
806:
807: SELECT NVL(MAX(freight_code), 'notfound')
808: INTO x_freight_code
809: FROM org_freight
810: WHERE organization_id = NVL(x_freight_carrier_record.to_organization_id, organization_id)
811: AND freight_code = x_freight_carrier_record.freight_carrier_code
812: AND NVL(disable_date, SYSDATE + 1) > SYSDATE;
813: