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.JAI_TAX_PROCESSING_PKG dependencies on OE_ORDER_LINES

Line 76: rec_old_ool OE_ORDER_LINES_ALL%ROWTYPE;

72:
73: -- added by zhiwei.xin for ZX integration of OM part on 2-AUG-2012 begin.
74: rec_jsl JAI_OM_OE_SO_LINES%ROWTYPE;
75: rec_jrl JAI_OM_OE_RMA_LINES%ROWTYPE;
76: rec_old_ool OE_ORDER_LINES_ALL%ROWTYPE;
77: -- added by zhiwei.xin for ZX integration of OM part on 2-AUG-2012 end.
78:
79:
80: --get distribution lines in one invoice

Line 118: cursor c_order_lines_entry(cp_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE)

114: --Added by Cholei for bug#14189751 end
115:
116: --Added by Zhiwei.xin for ZX integration of OM part begin
117: -- cursor to get newly created SO
118: cursor c_order_lines_entry(cp_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE)
119: is
120: select *
121: from OE_ORDER_LINES_ALL oola
122: where oola.HEADER_ID = cp_header_id

Line 121: from OE_ORDER_LINES_ALL oola

117: -- cursor to get newly created SO
118: cursor c_order_lines_entry(cp_header_id OE_ORDER_LINES_ALL.HEADER_ID%TYPE)
119: is
120: select *
121: from OE_ORDER_LINES_ALL oola
122: where oola.HEADER_ID = cp_header_id
123: and not exists (select 1
124: from JAI_OM_OE_RMA_LINES joorl
125: where joorl.RMA_HEADER_ID = cp_header_id

Line 133: cursor c_order_lines_update(cp_header_id OE_ORDER_LINES.HEADER_ID%TYPE)

129: where joosl.HEADER_ID = cp_header_id
130: and oola.LINE_ID = joosl.LINE_ID);
131:
132: -- cursor to get existing SO Lines
133: cursor c_order_lines_update(cp_header_id OE_ORDER_LINES.HEADER_ID%TYPE)
134: is
135: select *
136: from OE_ORDER_LINES oola
137: where oola.HEADER_ID = cp_header_id

Line 136: from OE_ORDER_LINES oola

132: -- cursor to get existing SO Lines
133: cursor c_order_lines_update(cp_header_id OE_ORDER_LINES.HEADER_ID%TYPE)
134: is
135: select *
136: from OE_ORDER_LINES oola
137: where oola.HEADER_ID = cp_header_id
138: and ( exists (select 1
139: from JAI_OM_OE_SO_LINES joosl
140: where joosl.HEADER_ID = cp_header_id

Line 498: ja_in_oe_order_lines_aiu_trg trigger and then the inserts the same in the

494: /*
495: 1. When inventory item has been changed in the base apps screen then, the
496: sales order form should also update the same and redefault the taxes. This
497: has been achieved ny deleteing the order and tax lines in the
498: ja_in_oe_order_lines_aiu_trg trigger and then the inserts the same in the
499: normal course of execution.
500: 2. Copy of Legacy Rma return order to another return order has also been made
501: possible due to this fix.
502: 3. When ever a copied line is split then the line number and shipment line