eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_FPA_UTIL dependencies on FTE_INVOICE_HEADERS

Line 22: FROM FTE_INVOICE_HEADERS FH,

18: IS
19: SELECT PV.PARTY_ID,PVS.PARTY_SITE_ID,
20: FH.SUPPLIER_SITE_ID,FH.ORG_ID,
21: NULL PAYMENT_METHOD_LOOKUP_CODE
22: FROM FTE_INVOICE_HEADERS FH,
23: PO_VENDORS PV,
24: PO_VENDOR_SITES_ALL PVS
25: WHERE
26: FH.SUPPLIER_ID = PV.VENDOR_ID

Line 223: FROM FTE_INVOICE_HEADERS

219: CURSOR C_APPROVED_AMOUNT(p_bol_no VARCHAR2)
220: IS
221: SELECT nvl(APPROVED_AMOUNT,0),
222: CURRENCY_CODE
223: FROM FTE_INVOICE_HEADERS
224: WHERE BOL = p_bol_no;
225:
226: -- 2 Gets the Total Rated Amount for the Trip
227:

Line 601: FROM FTE_INVOICE_HEADERS FH,

597: IS
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

Line 621: FROM FTE_INVOICE_HEADERS FH,

617: IS
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'

Line 634: FROM FTE_INVOICE_HEADERS FH,

630: IS
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'

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:

Line 723: SELECT nvl(freight_audit_line_level,'N'),FTE_INVOICE_HEADERS.APPROVED_AMOUNT

719: -- Get line level audit value
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:

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:

Line 726: AND FTE_INVOICE_HEADERS.INVOICE_HEADER_ID = p_invoice_header_id;

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:
730: l_summary_amount NUMBER;

Line 1217: decode( (select distinct WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH

1213: CURSOR C_SOURCE_LINE_BOLS ( p_source_line_id NUMBER,p_bol VARCHAR2)
1214: IS
1215: SELECT SUM(A.bol_flag) FROM (
1216: SELECT distinct wdl.delivery_leg_id,
1217: decode( (select distinct WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH
1218: where
1219: WDI.ENTITY_ID = DECODE(WT.MODE_OF_TRANSPORT,'LTL',WDL.DELIVERY_LEG_ID,'TRUCK',WT.TRIP_ID)
1220: AND WDI.ENTITY_NAME = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
1221: AND WDI.SEQUENCE_NUMBER = FH.BOL

Line 1346: FROM FTE_INVOICE_HEADERS

1342:
1343: END IF;
1344:
1345: SELECT BILL_STATUS INTO l_bill_status
1346: FROM FTE_INVOICE_HEADERS
1347: WHERE invoice_header_id = p_invoice_header_id;
1348:
1349:
1350: IF l_debug_on THEN

Line 1407: FROM FTE_INVOICE_HEADERS

1403:
1404: IF src_det.MODE_OF_TRANSPORT = 'LTL' THEN
1405:
1406: SELECT BILL_TYPE, BOL INTO l_bill_type, l_inc_parent_bol
1407: FROM FTE_INVOICE_HEADERS
1408: WHERE INVOICE_HEADER_ID = p_invoice_header_id;
1409:
1410:
1411: IF l_debug_on THEN

Line 1580: decode( (select WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH

1576: CURSOR C_SOURCE_LINE_BOLS ( p_source_line_id NUMBER,p_bol VARCHAR2)
1577: IS
1578: SELECT SUM(A.bol_flag) FROM (
1579: SELECT distinct wdl.delivery_leg_id,
1580: decode( (select WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH
1581: where
1582: WDI.ENTITY_ID = DECODE(WT.MODE_OF_TRANSPORT,'LTL',WDL.DELIVERY_LEG_ID,'TRUCK',WT.TRIP_ID)
1583: AND WDI.ENTITY_NAME = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
1584: AND WDI.SEQUENCE_NUMBER = FH.BOL

Line 1753: FROM FTE_INVOICE_HEADERS

1749: IF src_det.MODE_OF_TRANSPORT = 'LTL'
1750: THEN
1751:
1752: SELECT BILL_TYPE, BOL INTO l_bill_type, l_inc_parent_bol
1753: FROM FTE_INVOICE_HEADERS
1754: WHERE INVOICE_HEADER_ID = p_invoice_header_id;
1755:
1756:
1757: IF l_debug_on THEN

Line 2193: FROM fte_invoice_headers

2189: l_invoice_number := get_c_invoice_rec.invoice_num;
2190: l_payment_status := get_c_invoice_rec.payment_status_flag;
2191:
2192: SELECT invoice_header_id into l_invoice_id
2193: FROM fte_invoice_headers
2194: WHERE bill_number = l_invoice_number;
2195:
2196: IF l_payment_status = 'Y' THEN
2197: UPDATE FTE_INVOICE_HEADERS

Line 2197: UPDATE FTE_INVOICE_HEADERS

2193: FROM fte_invoice_headers
2194: WHERE bill_number = l_invoice_number;
2195:
2196: IF l_payment_status = 'Y' THEN
2197: UPDATE FTE_INVOICE_HEADERS
2198: SET BILL_STATUS = 'PAID'
2199: WHERE BILL_NUMBER = l_invoice_number;
2200: --Commenting the code for Obsoletion of DBI APIs in 12.2
2201: --callDBI(l_invoice_id, 'UPDATE', returnStatus); BUG#11852550

Line 2203: UPDATE FTE_INVOICE_HEADERS

2199: WHERE BILL_NUMBER = l_invoice_number;
2200: --Commenting the code for Obsoletion of DBI APIs in 12.2
2201: --callDBI(l_invoice_id, 'UPDATE', returnStatus); BUG#11852550
2202: ELSIF l_payment_status = 'P' THEN
2203: UPDATE FTE_INVOICE_HEADERS
2204: SET BILL_STATUS = 'PARTIAL_PAID'
2205: WHERE BILL_NUMBER = l_invoice_number;
2206: --Commenting the code for Obsoletion of DBI APIs in 12.2
2207: --callDBI(l_invoice_id, 'UPDATE', returnStatus); BUG#11852550

Line 2230: from fte_invoice_headers

2226:
2227: CLOSE C_INVOICE;
2228:
2229: select invoice_header_id into l_invoice_id
2230: from fte_invoice_headers
2231: where bill_number = l_invoice_number;
2232:
2233: IF l_payment_status = 'Y' THEN
2234: UPDATE FTE_INVOICE_HEADERS

Line 2234: UPDATE FTE_INVOICE_HEADERS

2230: from fte_invoice_headers
2231: where bill_number = l_invoice_number;
2232:
2233: IF l_payment_status = 'Y' THEN
2234: UPDATE FTE_INVOICE_HEADERS
2235: SET BILL_STATUS = 'PAID'
2236: WHERE BILL_NUMBER = l_invoice_number;
2237:
2238: callDBI(l_invoice_id, 'UPDATE', returnStatus);

Line 2241: UPDATE FTE_INVOICE_HEADERS

2237:
2238: callDBI(l_invoice_id, 'UPDATE', returnStatus);
2239:
2240: ELSIF l_payment_status = 'P' THEN
2241: UPDATE FTE_INVOICE_HEADERS
2242: SET BILL_STATUS = 'PARTIALLY PAID'
2243: WHERE BILL_NUMBER = l_invoice_number;
2244:
2245: callDBI(l_invoice_id, 'UPDATE', returnStatus);