DBA Data[Home] [Help]

APPS.GMIALLOC dependencies on IC_ADJS_JNL

Line 591: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl

587: x_return_status :=FND_API.G_RET_STS_SUCCESS;
588:
589: SELECT count(1)
590: INTO OMSO_txn_count
591: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl
592: WHERE jnl.journal_id = pjournal_id
593: AND jnl.line_type = -1
594: AND jnl.lot_id > 0
595: AND pnd.item_id = jnl.item_id

Line 625: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl

621: allocations cannot be moved.
622: ***************************************************************** */
623: select count(1)
624: into OMSO_pick_confirmed_txn_count
625: FROM ic_tran_pnd pnd, ic_adjs_jnl jnl
626: WHERE jnl.journal_id = pjournal_id
627: AND jnl.line_type = -1
628: AND jnl.lot_id > 0
629: AND pnd.item_id = jnl.item_id