APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on IC_TRAN_PND

Line 231: ic_tran_pnd t

227: SELECT t.item_id, t.whse_code, -t.trans_qty
228: FROM
229: opi_dbi_inv_value_log sd,
230: sy_orgn_mst o,
231: ic_tran_pnd t
232: WHERE
233: sd.type = 'OID'
234: AND o.organization_id = sd.organization_id
235: AND t.co_code = o.orgn_code

Line 441: -- IC_TRAN_PND. Since the FOB = 'Receipt'

437: -- Current intransit inventory transfer activity is determined by
438: -- the transfer_status = 2 for a transfer_id in the
439: -- transfer master table, IC_XFER_MST. The transfer_id
440: -- is the same as the doc_id in the pending transaction tables,
441: -- IC_TRAN_PND. Since the FOB = 'Receipt'
442: -- always, only the shipment lines in the transaction
443: -- tables will contribute to the intransit inventory of the
444: -- shipping warehouse.
445: -- Note that incomplete inventory transfers (i.e. ones that have

Line 447: -- balances) are found only in IC_TRAN_PND.

443: -- tables will contribute to the intransit inventory of the
444: -- shipping warehouse.
445: -- Note that incomplete inventory transfers (i.e. ones that have
446: -- not been received and therefore contribute to current intransit
447: -- balances) are found only in IC_TRAN_PND.
448: -- The pnd tables store -ve quantities for shipments which increase
449: -- intransit and positive quantities for receipts which decrease
450: -- intransit inventory. So quantity signs need to be reversed.
451: SELECT

Line 456: ic_tran_pnd pnd,

452: pnd.whse_code whse,
453: pnd.item_id item,
454: (-1 * pnd.trans_qty) qty
455: FROM
456: ic_tran_pnd pnd,
457: ic_xfer_mst xfer,
458: sy_orgn_mst o,
459: opi_dbi_inv_value_log sd
460: WHERE

Line 587: FROM ic_tran_pnd

583: (-1 * ic_tran.trans_qty) qty
584: FROM (SELECT doc_type, doc_id, line_id, co_code, whse_code, item_id,
585: sum(trans_qty) trans_qty, trans_um, gl_posted_ind,
586: trans_date, completed_ind
587: FROM ic_tran_pnd
588: WHERE doc_type = 'OMSO'
589: AND completed_ind = 1
590: GROUP BY doc_type, doc_id, line_id, co_code, whse_code, item_id,
591: trans_um, gl_posted_ind, trans_date,

Line 643: FROM ic_tran_pnd

639: (-1 * ic_tran.trans_qty) qty
640: FROM (SELECT doc_type, doc_id, line_id, co_code, whse_code, item_id,
641: sum(trans_qty) trans_qty, trans_um, gl_posted_ind,
642: trans_date, completed_ind
643: FROM ic_tran_pnd
644: WHERE doc_type = 'PORC'
645: AND completed_ind = 1
646: GROUP BY doc_type, doc_id, line_id, co_code, whse_code, item_id,
647: trans_um, gl_posted_ind, trans_date,