[Home] [Help]
375: sl.txn_qty sl_txn_qty,
376: sl.txn_unit_price sl_txn_unit_price,
377: sl.ship_line_id
378: FROM
379: inl_ship_lines sl,
380: zx_lines zl
381: WHERE sl.ship_header_id = p_ship_header_id
382: AND sl.ship_line_src_type_code = 'PO'
383: AND sl.ship_line_source_id = zl.trx_line_id
391: FROM inl_adj_tax_lines_v tl,
392: inl_associations assoc
393: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
394: AND assoc.from_parent_table_id = tl.tax_line_id
395: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
396: AND tl.ship_header_id = p_ship_header_id
397: AND tl.source_parent_table_name = 'ZX_LINES'
398: ) tl_assoc
399: WHERE tl_assoc.source_parent_table_id(+) = sl_zx.tax_line_id
435: p_tax_ln_tbl(i).tax_code := zlines_tbl(i).tax;
436: p_tax_ln_tbl(i).ship_header_id := p_ship_header_id;
437: p_tax_ln_tbl(i).source_parent_table_name := 'ZX_LINES';
438: p_tax_ln_tbl(i).source_parent_table_id := zlines_tbl(i).tax_line_id;
439: p_tax_ln_tbl(i).to_parent_table_name := 'INL_SHIP_LINES';
440: p_tax_ln_tbl(i).to_parent_table_id := zlines_tbl(i).ship_line_id;
441: p_tax_ln_tbl(i).currency_code := zlines_tbl(i).tax_currency_code;
442: p_tax_ln_tbl(i).currency_conversion_type := zlines_tbl(i).tax_currency_conversion_type;
443: p_tax_ln_tbl(i).currency_conversion_date := zlines_tbl(i).tax_currency_conversion_date;
1794: ,zl.creation_date
1795: ,zl.last_updated_by
1796: ,zl.last_update_date
1797: ,zl.last_update_login
1798: ,DECODE(lv.source, 'SHIP_LINE' ,'INL_SHIP_LINES'
1799: , 'CHARGE' ,'INL_CHARGE_LINES') source
1800: ,oh.ship_TYPE_ID
1801: ,inl_tax_lines_s.NEXTVAL tax_line_id_s
1802: FROM zx_lines zl
1918: ,fnd_global.user_id /* 11 */
1919: ,SYSDATE /* 12 */
1920: ,fnd_global.login_id); /* 13 */
1921: END LOOP;
1922: UPDATE inl_ship_lines
1923: SET tax_already_calculated_flag = 'Y',
1924: last_updated_by = fnd_global.user_id,
1925: last_update_date = SYSDATE
1926: WHERE ship_header_id = p_ship_header_Id;