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 GL_SUBR_TST

Line 67: gl_subr_tst tst

63:
64: SELECT NVL(MIN(from_date), global_start_date) INTO l_from_date
65: FROM (SELECT tst.gl_trans_date from_date
66: FROM opi_dbi_cogs_run_log l,
67: gl_subr_tst tst
68: WHERE l.source = OPM_SOURCE
69: AND tst.subledger_id = l.start_txn_id
70: UNION
71: SELECT tst.gl_trans_date from_date

Line 186: (select /+index(tst,gl_subr_tst_n2) /

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
189: from gl_subr_tst tst
190: where tst.doc_type = 'PORC'

Line 189: from gl_subr_tst tst

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
189: from gl_subr_tst tst
190: where tst.doc_type = 'PORC'
191: and tst.acct_ttl_type = 5200
192: and tst.gl_trans_date >= global_start_date
193: group by tst.line_id, tst.doc_type, tst.gl_trans_date) tst

Line 209: (select /+index(tst,gl_subr_tst_n2) /

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
213: where tst.doc_type = 'OMSO'

Line 212: from gl_subr_tst tst

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
213: where tst.doc_type = 'OMSO'
214: and tst.acct_ttl_type = 5200
215: and tst.gl_trans_date >= global_start_date
216: group by tst.line_id, tst.doc_type, tst.gl_trans_date) tst

Line 438: from gl_subr_tst tst,

434: trunc(GL_TRANS_DATE) COGS_DATE ,
435: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID ,
436: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS ) TURNS_COGS_FLAG ,
437: OPM_SOURCE SOURCE
438: from gl_subr_tst tst,
439: oe_order_lines_all lines,
440: hz_cust_accounts cust_acct,
441: ic_whse_mst whse,
442: mtl_system_items_b msi,