DBA Data[Home] [Help]

APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on WSH_DOCUMENT_INSTANCES

Line 519: wsh_document_instances wdi,

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
523: WHERE fih.mode_of_transport = 'LTL'

Line 553: wsh_document_instances wdi,

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
557: WHERE fih.mode_of_transport = 'TL'

Line 1112: wsh_document_instances wdi,

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
1116: WHERE log.invoice_header_id = fih.invoice_header_id

Line 1148: wsh_document_instances wdi,

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
1152: WHERE log.invoice_header_id = fih.invoice_header_id