DBA Data[Home] [Help]

APPS.FTE_FPA_UTIL dependencies on WSH_CARRIERS

Line 724: FROM WSH_CARRIERS, FTE_INVOICE_HEADERS

720:
721: CURSOR C_GET_LINE_LEVEL_AUDIT_VALUE
722: IS
723: SELECT nvl(freight_audit_line_level,'N'),FTE_INVOICE_HEADERS.APPROVED_AMOUNT
724: FROM WSH_CARRIERS, FTE_INVOICE_HEADERS
725: WHERE WSH_CARRIERS.CARRIER_ID = FTE_INVOICE_HEADERS.CARRIER_ID
726: AND FTE_INVOICE_HEADERS.INVOICE_HEADER_ID = p_invoice_header_id;
727:
728:

Line 725: WHERE WSH_CARRIERS.CARRIER_ID = FTE_INVOICE_HEADERS.CARRIER_ID

721: CURSOR C_GET_LINE_LEVEL_AUDIT_VALUE
722: IS
723: SELECT nvl(freight_audit_line_level,'N'),FTE_INVOICE_HEADERS.APPROVED_AMOUNT
724: FROM WSH_CARRIERS, FTE_INVOICE_HEADERS
725: WHERE WSH_CARRIERS.CARRIER_ID = FTE_INVOICE_HEADERS.CARRIER_ID
726: AND FTE_INVOICE_HEADERS.INVOICE_HEADER_ID = p_invoice_header_id;
727:
728:
729: