[Home] [Help]
217: l_current_organization_id:= p_lci_table(i).organization_id;
218: l_current_location_id := p_lci_table(i).location_id;
219: END IF;
220:
221: SELECT INL_SHIP_LINES_INT_S.nextval
222: INTO l_ship_line_int_id
223: FROM dual;
224:
225: INL_LOGGING_PVT.Log_Variable (
227: p_procedure_name => l_api_name,
228: p_var_name => 'l_ship_line_int_id',
229: p_var_value => l_ship_line_int_id);
230:
231: INSERT INTO inl_ship_lines_int (
232: ship_header_int_id, /* 01 */
233: ship_line_int_id, /* 02 */
234: processing_status_code, /* 03 */
235: ship_line_group_reference, /* 04 */
1210: p_var_value => l_output_tax_classf_code);
1211: INL_LOGGING_PVT.Log_Statement (
1212: p_module_name => g_module_name,
1213: p_procedure_name => l_proc_name,
1214: p_debug_info => 'Insert inl_ship_lines_int values in PL/SQL table.');
1215:
1216: l_lci_table(l_ind_lci).ship_line_group_reference := l_receipt_num;
1217: l_lci_table(l_ind_lci).party_id := l_party_id;
1218: l_lci_table(l_ind_lci).party_site_id := l_party_site_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
2329: AND rtr.po_line_location_id = isl.ship_line_source_id
2710: x_currency_code,
2711: x_currency_conversion_type,
2712: x_currency_conversion_date,
2713: x_currency_conversion_rate
2714: FROM inl_ship_lines_all sl
2715: WHERE sl.ship_line_id = p_ship_line_id;
2716:
2717: -- End of Api Body
2718:
3831: AND pl.po_header_id = s.parent_table_id
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'
3975: sl.txn_qty,
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