DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on WIP_MOVE_TXN_INTERFACE

Line 2247: -- wip_move_txn_interface

2243: --
2244: -- PROCEDURE get_move_transaction_lines
2245: --
2246: -- This procedure returns a table of move transaction records from
2247: -- wip_move_txn_interface
2248: -- Used to match with WIP reservation while processing scrap transactions.
2249: --
2250: --
2251: -- Internal helper

Line 2275: from wip_move_txn_interface wmti

2271: primary_uom,
2272: entity_type,
2273: repetitive_schedule_id,
2274: transaction_date
2275: from wip_move_txn_interface wmti
2276: where wmti.group_id = p_group_id
2277: and wmti.process_phase = 2
2278: and wmti.process_status = 2
2279: and wmti.wip_entity_id = p_wip_entity_id

Line 2341: from wip_move_txn_interface wmti, wip_discrete_jobs wdj

2337: wdj.primary_item_id,
2338: wdj.start_quantity,
2339: wdj.quantity_completed,
2340: wdj.quantity_scrapped
2341: from wip_move_txn_interface wmti, wip_discrete_jobs wdj
2342: where wmti.group_id = p_group_id
2343: and wmti.wip_entity_id = wdj.wip_entity_id
2344: and wmti.organization_id = wdj.organization_id
2345: and wmti.process_phase = 2