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 WSH_FREIGHT_COSTS

Line 233: FROM WSH_FREIGHT_COSTS WFC,

229: IS
230: SELECT
231: nvl(WFC.TOTAL_AMOUNT,0),
232: WFC.CURRENCY_CODE
233: FROM WSH_FREIGHT_COSTS WFC,
234: WSH_FREIGHT_COST_TYPES CT
235: WHERE
236: WFC.FREIGHT_COST_TYPE_ID = CT.FREIGHT_COST_TYPE_ID
237: AND WFC.LINE_TYPE_CODE = 'SUMMARY'

Line 250: WSH_FREIGHT_COSTS WFC

246: WFC.CURRENCY_CODE
247: FROM
248: WSH_DELIVERY_LEGS WDL ,
249: WSH_TRIP_STOPS WT,
250: WSH_FREIGHT_COSTS WFC
251: WHERE
252: WT.STOP_ID = WDL.PICK_UP_STOP_ID
253: AND WFC.DELIVERY_LEG_ID = WDL.DELIVERY_LEG_ID
254: AND WT.TRIP_ID = p_trip

Line 301: WSH_FREIGHT_COSTS WFC

297: SELECT
298: nvl(WFC.TOTAL_AMOUNT,0) ,
299: WFC.CURRENCY_CODE
300: FROM
301: WSH_FREIGHT_COSTS WFC
302: WHERE
303: WFC.DELIVERY_LEG_ID = p_dleg_id
304: AND WFC.DELIVERY_DETAIL_ID = DECODE (p_cont_flag,'Y',p_container_detail_id,'N',p_detail_id)
305: AND WFC.LINE_TYPE_CODE = 'SUMMARY';

Line 552: FROM WSH_FREIGHT_COSTS

548: IS
549: SELECT
550: nvl( SUM(TOTAL_AMOUNT),0),
551: MAX(CURRENCY_CODE)
552: FROM WSH_FREIGHT_COSTS
553: WHERE
554: DELIVERY_LEG_ID = p_delivery_leg_id
555: AND LINE_TYPE_CODE = 'SUMMARY'
556: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE';

Line 564: FROM WSH_FREIGHT_COSTS

560: IS
561: SELECT
562: nvl( SUM(TOTAL_AMOUNT),0),
563: MAX(CURRENCY_CODE)
564: FROM WSH_FREIGHT_COSTS
565: WHERE
566: DELIVERY_LEG_ID = p_delivery_leg_id
567: AND LINE_TYPE_CODE = 'DISCOUNT'
568: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE';

Line 576: FROM WSH_FREIGHT_COSTS

572: IS
573: SELECT
574: nvl( SUM(TOTAL_AMOUNT),0),
575: MAX(CURRENCY_CODE)
576: FROM WSH_FREIGHT_COSTS
577: WHERE
578: DELIVERY_LEG_ID = p_delivery_leg_id
579: AND LINE_TYPE_CODE = 'CHARGE'
580: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE';

Line 587: FROM WSH_FREIGHT_COSTS

583: IS
584: SELECT
585: nvl( SUM(TOTAL_AMOUNT),0),
586: MAX(CURRENCY_CODE)
587: FROM WSH_FREIGHT_COSTS
588: WHERE
589: DELIVERY_LEG_ID = p_delivery_leg_id
590: AND LINE_TYPE_CODE = 'PRICE'
591: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'

Line 645: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS

641:
642: CURSOR C_LINE_APPROVED_DISCOUNT(p_dleg_id NUMBER,p_bol_no VARCHAR2,p_commodity_id NUMBER)
643: IS
644: SELECT
645: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS
646: WHERE DELIVERY_LEG_ID = p_dleg_id
647: AND LINE_TYPE_CODE = 'DISCOUNT'
648: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
649: AND COMMODITY_CATEGORY_ID = p_commodity_id

Line 651: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS

647: AND LINE_TYPE_CODE = 'DISCOUNT'
648: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
649: AND COMMODITY_CATEGORY_ID = p_commodity_id
650: ) /
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

Line 664: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS

660:
661: CURSOR C_LINE_APPROVED_SURCHARGE(p_dleg_id NUMBER,p_bol_no VARCHAR2,p_commodity_id NUMBER)
662: IS
663: SELECT
664: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS
665: WHERE DELIVERY_LEG_ID = p_dleg_id
666: AND LINE_TYPE_CODE = 'CHARGE'
667: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
668: AND COMMODITY_CATEGORY_ID = p_commodity_id

Line 670: (SELECT SUM(TOTAL_AMOUNT) FROM WSH_FREIGHT_COSTS

666: AND LINE_TYPE_CODE = 'CHARGE'
667: AND CHARGE_SOURCE_CODE= 'PRICING_ENGINE'
668: AND COMMODITY_CATEGORY_ID = p_commodity_id
669: ) /
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

Line 686: FROM wsh_freight_costs

682: CURSOR C_DETAIL_AMOUNT
683: IS
684: SELECT nvl(total_amount,0),
685: currency_code
686: FROM wsh_freight_costs
687: WHERE DELIVERY_LEG_ID = p_delivery_leg_id
688: AND DELIVERY_DETAIL_ID = p_delivery_detail_id
689: AND LINE_TYPE_CODE = 'PRICE'
690: AND CHARGE_SOURCE_CODE = 'PRICING_ENGINE'

Line 699: FROM wsh_freight_costs

695: CURSOR C_DETAIL_DISCOUNT_AMOUNT
696: IS
697: SELECT nvl(total_amount,0),
698: currency_code
699: FROM wsh_freight_costs
700: WHERE DELIVERY_LEG_ID = p_delivery_leg_id
701: AND DELIVERY_DETAIL_ID = p_delivery_detail_id
702: AND LINE_TYPE_CODE = 'DISCOUNT'
703: AND CHARGE_SOURCE_CODE = 'PRICING_ENGINE'

Line 711: FROM wsh_freight_costs

707: CURSOR C_DETAIL_SURCHARGE_AMOUNT
708: IS
709: SELECT nvl(total_amount,0),
710: currency_code
711: FROM wsh_freight_costs
712: WHERE DELIVERY_LEG_ID = p_delivery_leg_id
713: AND DELIVERY_DETAIL_ID = p_delivery_detail_id
714: AND LINE_TYPE_CODE = 'CHARGE'
715: AND CHARGE_SOURCE_CODE = 'PRICING_ENGINE'