APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on FTE_INVOICE_HEADERS

Line 518: FROM fte_invoice_headers fih,

514: idl.delivery_leg_id DELIVERY_LEG_ID,
515: idl.trip_id TRIP_ID,
516: fih.currency_code TRX_CURRENCY_CODE,
517: gsb.currency_code WH_CURRENCY_CODE
518: FROM fte_invoice_headers fih,
519: wsh_document_instances wdi,
520: isc_dbi_tmp_del_legs idl,
521: ar_system_parameters_all aspa,
522: gl_sets_of_books gsb

Line 552: FROM fte_invoice_headers fih,

548: null DELIVERY_LEG_ID,
549: itr.trip_id TRIP_ID,
550: fih.currency_code TRX_CURRENCY_CODE,
551: gsb.currency_code WH_CURRENCY_CODE
552: FROM fte_invoice_headers fih,
553: wsh_document_instances wdi,
554: isc_dbi_tmp_trip_stops itr,
555: ar_system_parameters_all aspa,
556: gl_sets_of_books gsb

Line 1062: WHERE NOT EXISTS (select '1' from fte_invoice_headers fih

1058:
1059: DELETE FROM isc_dbi_fte_invoices_f
1060: WHERE invoice_header_id IN (SELECT DISTINCT log.invoice_header_id
1061: FROM isc_dbi_tmp_fih_log log
1062: WHERE NOT EXISTS (select '1' from fte_invoice_headers fih
1063: where fih.invoice_header_id = log.invoice_header_id
1064: and fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')));
1065:
1066: FII_UTIL.Stop_Timer;

Line 1111: fte_invoice_headers fih,

1107: idl.trip_id TRIP_ID,
1108: fih.currency_code TRX_CURRENCY_CODE,
1109: gsb.currency_code WH_CURRENCY_CODE
1110: FROM (select distinct invoice_header_id from isc_dbi_tmp_fih_log) log,
1111: fte_invoice_headers fih,
1112: wsh_document_instances wdi,
1113: isc_dbi_del_legs_f idl,
1114: ar_system_parameters_all aspa,
1115: gl_sets_of_books gsb

Line 1147: fte_invoice_headers fih,

1143: itr.trip_id TRIP_ID,
1144: fih.currency_code TRX_CURRENCY_CODE,
1145: gsb.currency_code WH_CURRENCY_CODE
1146: FROM (select distinct invoice_header_id from isc_dbi_tmp_fih_log) log,
1147: fte_invoice_headers fih,
1148: wsh_document_instances wdi,
1149: isc_dbi_trip_stops_f itr,
1150: ar_system_parameters_all aspa,
1151: gl_sets_of_books gsb