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.OPI_DBI_COGS_OPM_PKG dependencies on IC_TRAN_PND

Line 178: (select /+ leading(tst) index(tran,IC_TRAN_PNDI2) use_nl(tran) / rcv.oe_order_line_id oe_order_line_id,

174: from oe_order_lines_all lines,
175: hz_cust_accounts cust_acct,
176: ic_whse_mst whse,
177: mtl_system_items_b msi,
178: (select /*+ leading(tst) index(tran,IC_TRAN_PNDI2) use_nl(tran) */ rcv.oe_order_line_id oe_order_line_id,
179: tran.line_id,
180: tran.orgn_code,
181: tran.whse_code,
182: tst.gl_trans_date,

Line 184: from ic_tran_pnd tran,

180: tran.orgn_code,
181: tran.whse_code,
182: tst.gl_trans_date,
183: avg(tst.cogs_val_b) COGS_VAL_B
184: from ic_tran_pnd tran,
185: rcv_transactions rcv,
186: (select /*+index(tst,gl_subr_tst_n2) */
187: tst.line_id, tst.doc_type, tst.gl_trans_date,
188: sum(tst.debit_credit_sign*tst.amount_base) COGS_VAL_B

Line 202: select /+ leading(tst) index(tran,IC_TRAN_PNDI2) use_nl(tran) / tran.line_id oe_order_line_id,

198: and tran.doc_type = tst.doc_type
199: and tran.line_id = tst.line_id
200: group by rcv.oe_order_line_id, tran.line_id, tran.orgn_code, tran.whse_code, tst.gl_trans_date
201: union all
202: select /*+ leading(tst) index(tran,IC_TRAN_PNDI2) use_nl(tran) */ tran.line_id oe_order_line_id,
203: tran.line_id,
204: tran.orgn_code,
205: tran.whse_code,
206: tst.gl_trans_date,

Line 208: from ic_tran_pnd tran,

204: tran.orgn_code,
205: tran.whse_code,
206: tst.gl_trans_date,
207: avg(tst.cogs_val_b) COGS_VAL_B
208: from ic_tran_pnd tran,
209: (select /*+index(tst,gl_subr_tst_n2) */
210: tst.line_id, tst.doc_type, tst.gl_trans_date,
211: sum(tst.debit_credit_sign*tst.amount_base) COGS_VAL_B
212: from gl_subr_tst tst

Line 290: from ic_tran_pnd tran,

286: tran.orgn_code,
287: tran.whse_code,
288: tst.gl_trans_date,
289: avg(tst.cogs_val_b) COGS_VAL_B
290: from ic_tran_pnd tran,
291: rcv_transactions rcv,
292: (select /*+ index(tst,GL_SUBR_LED_PK) */
293: tst.line_id, tst.doc_type, tst.gl_trans_date,
294: sum(tst.debit_credit_sign*tst.amount_base) COGS_VAL_B

Line 317: from ic_tran_pnd tran,

313: tran.orgn_code,
314: tran.whse_code,
315: tst.gl_trans_date,
316: avg(tst.cogs_val_b) COGS_VAL_B
317: from ic_tran_pnd tran,
318: (select /*+ index(tst,GL_SUBR_LED_PK) */
319: tst.line_id, tst.doc_type, tst.gl_trans_date,
320: sum(tst.debit_credit_sign*tst.amount_base) COGS_VAL_B
321: from gl_subr_led tst

Line 450: from ic_tran_pnd tran,

446: rcv.oe_order_line_id oe_order_line_id,
447: tran.line_id,
448: tran.orgn_code,
449: tran.whse_code
450: from ic_tran_pnd tran,
451: rcv_transactions rcv
452: where doc_type = 'PORC'
453: and completed_ind = 1
454: and gl_posted_ind = 0

Line 465: from ic_tran_pnd tran

461: tran.line_id oe_order_line_id,
462: tran.line_id,
463: tran.orgn_code,
464: tran.whse_code
465: from ic_tran_pnd tran
466: where doc_type = 'OMSO'
467: and completed_ind = 1
468: and gl_posted_ind = 0
469: group by doc_type, line_id, line_id, orgn_code, whse_code

Line 543: from ic_tran_pnd tran,

539: rcv.oe_order_line_id oe_order_line_id,
540: tran.line_id,
541: tran.orgn_code,
542: tran.whse_code
543: from ic_tran_pnd tran,
544: rcv_transactions rcv
545: where doc_type = 'PORC'
546: and completed_ind = 1
547: and gl_posted_ind = 1

Line 558: from ic_tran_pnd tran

554: tran.line_id oe_order_line_id,
555: tran.line_id,
556: tran.orgn_code,
557: tran.whse_code
558: from ic_tran_pnd tran
559: where doc_type = 'OMSO'
560: and completed_ind = 1
561: and gl_posted_ind = 1
562: group by doc_type, line_id, line_id, orgn_code, whse_code) tran,