APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on GL_SETS_OF_BOOKS

Line 463: gl_sets_of_books gsb

459: AND wfct.name = 'SUMMARY'
460: AND wfct.freight_cost_type_code = 'FTESUMMARY') ifc,
461: isc_dbi_tmp_trip_stops its,
462: hr_organization_information hoi,
463: gl_sets_of_books gsb
464: WHERE wdl.delivery_id = wnd.delivery_id
465: AND wnd.initial_pickup_date >= g_global_start_date
466: AND nvl(wnd.shipping_control, 'NA') <> 'SUPPLIER'
467: AND wdl.pick_up_stop_id = its.stop_id

Line 522: gl_sets_of_books gsb

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
526: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

Line 556: gl_sets_of_books gsb

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
560: AND wdi.entity_name = 'WSH_TRIPS'

Line 946: gl_sets_of_books gsb

942: AND wfct.name = 'SUMMARY'
943: AND wfct.freight_cost_type_code = 'FTESUMMARY') ifc,
944: isc_dbi_tmp_trip_stops its,
945: hr_organization_information hoi,
946: gl_sets_of_books gsb
947: WHERE wdl.delivery_id = wnd.delivery_id
948: AND wnd.initial_pickup_date >= g_global_start_date
949: AND nvl(wnd.shipping_control, 'NA') <> 'SUPPLIER'
950: AND wdl.pick_up_stop_id = its.stop_id

Line 1115: gl_sets_of_books gsb

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')
1119: AND fih.bol = wdi.sequence_number

Line 1151: gl_sets_of_books gsb

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')
1155: AND fih.bol = wdi.sequence_number