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_LED

Line 73: gl_subr_led tst

69: AND tst.subledger_id = l.start_txn_id
70: UNION
71: SELECT tst.gl_trans_date from_date
72: FROM opi_dbi_cogs_run_log l,
73: gl_subr_led tst
74: WHERE l.source = OPM_SOURCE
75: AND tst.subledger_id = l.start_txn_id
76: );
77:

Line 292: (select /+ index(tst,GL_SUBR_LED_PK) /

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
295: from gl_subr_led tst
296: where tst.doc_type = 'PORC'

Line 295: from gl_subr_led tst

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
295: from gl_subr_led tst
296: where tst.doc_type = 'PORC'
297: and tst.acct_ttl_type = 5200
298: and tst.subledger_id between p_last_id and p_newest_id
299: and tst.GL_TRANS_DATE >= global_start_date

Line 318: (select /+ index(tst,GL_SUBR_LED_PK) /

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

Line 321: from gl_subr_led tst

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
322: where tst.doc_type = 'OMSO'
323: and tst.acct_ttl_type = 5200
324: and tst.subledger_id between p_last_id and p_newest_id
325: and tst.GL_TRANS_DATE >= global_start_date

Line 536: from gl_subr_led tst,

532: trunc(GL_TRANS_DATE) COGS_DATE ,
533: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID ,
534: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS) TURNS_COGS_FLAG ,
535: OPM_SOURCE SOURCE
536: from gl_subr_led tst,
537: (select /*+ full(tran) full(rcv) use_hash(tran) parallel(tran) parallel(rcv) */
538: tran.doc_type,
539: rcv.oe_order_line_id oe_order_line_id,
540: tran.line_id,

Line 657: from gl_subr_led led

653:
654:
655: SELECT NVL(MAX(subledger_id),l_last_trx_id)
656: INTO l_new_trx_id
657: from gl_subr_led led
658: where led.doc_type in ( 'OMSO', 'PORC')
659: and led.acct_ttl_type = 5200
660: AND led.gl_trans_date >= global_start_date
661: AND led.subledger_id >= l_last_trx_id;

Line 671: from gl_subr_led led

667: SELECT Nvl(MIN(subledger_id),0) - 1,
668: Nvl(MAX(subledger_id),0)
669: INTO l_last_trx_id,
670: l_new_trx_id
671: from gl_subr_led led
672: where led.doc_type in ( 'OMSO', 'PORC')
673: and led.acct_ttl_type = 5200
674: AND led.gl_trans_date >= global_start_date;
675:

Line 780: from gl_subr_led tst

776: SELECT Nvl(MIN(subledger_id),0),
777: Nvl(MAX(subledger_id),0)
778: INTO l_last_trx_id,
779: l_new_trx_id
780: from gl_subr_led tst
781: where tst.doc_type in ( 'OMSO', 'PORC' )
782: and tst.acct_ttl_type = 5200
783: AND tst.gl_trans_date >= global_start_date;
784: