DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on WSM_LOT_MOVE_TXN_INTERFACE

Line 162: Added check on two new interface tables wsm_lot_move_txn_interface

158: x_uncost_wsm := 0;
159:
160: -- Pending WSM interface transactions (must resolve)
161: /* Bug# 3926917: Period Close Diagnostics Project
162: Added check on two new interface tables wsm_lot_move_txn_interface
163: And wsm_lot_split_merges_interface */
164:
165: BEGIN
166:

Line 184: FROM wsm_lot_move_txn_interface

180: -- Pending Lot Move Transactions Interface
181:
182: SELECT COUNT(*)
183: INTO l_tcount
184: FROM wsm_lot_move_txn_interface
185: WHERE organization_id = p_org_id
186: AND status <> wip_constants.completed
187: AND transaction_date <= l_sched_close_date;
188: