[Home] [Help]
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'
524: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')
525: AND fih.bol = wdi.sequence_number
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'
558: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')
559: AND fih.bol = wdi.sequence_number
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
1117: AND fih.mode_of_transport = 'LTL'
1118: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')
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
1153: AND fih.mode_of_transport = 'TL'
1154: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')