APPS.OPI_DBI_COGS_OPM_PKG dependencies on RCV_TRANSACTIONS

Line 185: rcv_transactions rcv,

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
189: from gl_subr_tst tst

Line 291: rcv_transactions rcv,

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
295: from gl_subr_led tst

Line 451: rcv_transactions rcv

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
455: and tran.line_id = rcv.transaction_id

Line 544: rcv_transactions rcv

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
548: and tran.line_id = rcv.transaction_id