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.INL_INTEGRATION_GRP dependencies on INL_SHIP_HEADERS

Line 128: SELECT INL_SHIP_HEADERS_INT_S.nextval, INL_INTERFACE_GROUPS_S.nextval

124: IF ((l_current_organization_id <> p_lci_table(i).organization_id OR
125: l_current_location_id <> p_lci_table(i).location_id)OR
126: l_current_shipment_header_id <> p_lci_table(i).hdr_interface_source_line_id) THEN -- Bug #9232742
127:
128: SELECT INL_SHIP_HEADERS_INT_S.nextval, INL_INTERFACE_GROUPS_S.nextval
129: INTO l_ship_header_int_id, l_group_id
130: FROM dual;
131:
132: p_lci_table(i).group_id := l_group_id; -- Bug#9279355

Line 149: p_debug_info => 'Inserting into inl_ship_headers_int' );

145:
146: INL_LOGGING_PVT.Log_Statement (
147: p_module_name => g_module_name,
148: p_procedure_name => l_api_name,
149: p_debug_info => 'Inserting into inl_ship_headers_int' );
150:
151: INSERT INTO inl_ship_headers_int(
152: ship_header_int_id, /* 01 */
153: group_id, /* 02 */

Line 151: INSERT INTO inl_ship_headers_int(

147: p_module_name => g_module_name,
148: p_procedure_name => l_api_name,
149: p_debug_info => 'Inserting into inl_ship_headers_int' );
150:
151: INSERT INTO inl_ship_headers_int(
152: ship_header_int_id, /* 01 */
153: group_id, /* 02 */
154: transaction_type, /* 03 */
155: processing_status_code, /* 04 */

Line 928: p_debug_info => 'Insert into inl_ship_headers_int table');

924: p_var_value => l_group_id);
925: INL_LOGGING_PVT.Log_Statement (
926: p_module_name => g_module_name,
927: p_procedure_name => l_proc_name,
928: p_debug_info => 'Insert into inl_ship_headers_int table');
929:
930: END IF;
931: l_lci_table(l_ind_lci).shipment_header_id := p_int_rec(i).shipment_header_id; --Bug#8971617
932: l_lci_table(l_ind_lci).header_interface_id := p_int_rec(i).header_interface_id;

Line 2324: FROM inl_ship_headers ish,

2320: isl.inventory_item_id,
2321: isl.parent_ship_line_id,
2322: isl.ship_line_num,
2323: rtr.transaction_id
2324: FROM inl_ship_headers ish,
2325: inl_ship_lines isl,
2326: rcv_transactions rtr,
2327: mtl_parameters mp --BUG#8933768
2328: WHERE ish.ship_header_id = isl.ship_header_id

Line 3836: inl_ship_headers sh

3832: AND s.parent_table_name = 'PO_HEADERS'
3833: AND s.simulation_id = p_simulation_id
3834: AND NOT EXISTS (SELECT sl.ship_line_id
3835: FROM inl_ship_lines sl,
3836: inl_ship_headers sh
3837: WHERE sh.ship_header_id = sl.ship_header_id
3838: AND sl.ship_line_source_id = pll.line_location_id
3839: AND sl.ship_line_src_type_code = 'PO'
3840: AND sh.simulation_id = s.simulation_id)

Line 3980: inl_ship_headers sh,

3976: muv.unit_of_measure,
3977: sl.txn_unit_price,
3978: sl.currency_code
3979: FROM inl_ship_lines_all sl,
3980: inl_ship_headers sh,
3981: mtl_units_of_measure_vl muv
3982: WHERE muv.uom_code = sl.txn_uom_code
3983: AND sl.ship_header_id = sh.ship_header_id
3984: AND sl.ship_line_src_type_code = 'PO'