APPS.FTE_FPA_UTIL dependencies on FTE_INVOICE_LINES

Line 602: FTE_INVOICE_LINES FL,

598: SELECT
599: NVL( SUM(FL.APPROVED_AMOUNT),0 ),
600: MAX(FH.CURRENCY_CODE)
601: FROM FTE_INVOICE_HEADERS FH,
602: FTE_INVOICE_LINES FL,
603: MTL_CATEGORIES_KFV C,
604: MTL_CATEGORY_SETS S
605: WHERE FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
606: AND FH.BOL = p_bol

Line 622: FTE_INVOICE_LINES FL

618: SELECT
619: NVL( SUM(FL.APPROVED_AMOUNT),0 ),
620: MAX(FH.CURRENCY_CODE)
621: FROM FTE_INVOICE_HEADERS FH,
622: FTE_INVOICE_LINES FL
623: WHERE FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
624: AND FH.BOL = p_bol
625: AND FH.BILL_STATUS <> 'OBSOLETE'
626: AND FL.INVOICE_LINE_TYPE = 'DISCOUNT';

Line 635: FTE_INVOICE_LINES FL

631: SELECT
632: NVL( SUM(FL.APPROVED_AMOUNT),0 ),
633: MAX(FH.CURRENCY_CODE)
634: FROM FTE_INVOICE_HEADERS FH,
635: FTE_INVOICE_LINES FL
636: WHERE FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
637: AND FH.BOL = p_bol
638: AND FH.BILL_STATUS <> 'OBSOLETE'
639: AND FL.INVOICE_LINE_TYPE = 'SURCHARGE';

Line 655: ) * FL.APPROVED_AMOUNT FROM FTE_INVOICE_LINES FL ,FTE_INVOICE_HEADERS FH

651: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS
652: WHERE DELIVERY_LEG_ID = p_dleg_id
653: AND LINE_TYPE_CODE = 'DISCOUNT'
654: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
655: ) * FL.APPROVED_AMOUNT FROM FTE_INVOICE_LINES FL ,FTE_INVOICE_HEADERS FH
656: WHERE FL.INVOICE_LINE_TYPE ='DISCOUNT'
657: AND FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
658: AND FH.BOL = p_bol_no;
659:

Line 674: ) * FL.APPROVED_AMOUNT FROM FTE_INVOICE_LINES FL ,FTE_INVOICE_HEADERS FH

670: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS
671: WHERE DELIVERY_LEG_ID = p_dleg_id
672: AND LINE_TYPE_CODE = 'CHARGE'
673: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
674: ) * FL.APPROVED_AMOUNT FROM FTE_INVOICE_LINES FL ,FTE_INVOICE_HEADERS FH
675: WHERE FL.INVOICE_LINE_TYPE ='SURCHARGE'
676: AND FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
677: AND FH.BOL = p_bol_no;
678: