APPS.CSTPPWRO dependencies on WIP_MOVE_TRANSACTIONS

Line 466: -- WIP_MOVE_TRANSACTIONS table does not store rep schedule_id

462: -- are being charged. We can only have rollforward or rollbackward
463: -- between schedules that have the same routing. In other words,
464: -- all schedules in wip_txn_allocations tables for a given
465: -- wip_transaction_id WILL HAVE THE SAME ROUTING.
466: -- WIP_MOVE_TRANSACTIONS table does not store rep schedule_id
467: -- therefore the only way to find the schedule (and thus the
468: -- routing) for which this move transaction is being done is to
469: -- join to wip_txn and wip_txn_alloc tables and get the appropriate
470: -- schedule_id.

Line 500: wip_move_transactions wmt

496: wmt.fm_intraoperation_step_type fm_step,
497: wmt.to_intraoperation_step_type to_step,
498: wmt.primary_quantity pri_qty
499: FROM
500: wip_move_transactions wmt
501: WHERE wmt.wip_entity_id = p_entity_id
502: AND wmt.transaction_date BETWEEN TRUNC(p_start_date)
503: AND (TRUNC(p_end_date) + 0.99999)
504: AND NOT ( wmt.fm_operation_seq_num = wmt.to_operation_seq_num

Line 983: FROM wip_move_transactions wmt

979: AND we.entity_type <> 4 -- NOT CFM
980: AND we.primary_item_id IS NOT NULL
981: AND EXISTS
982: ( SELECT 'X'
983: FROM wip_move_transactions wmt
984: WHERE wmt.wip_entity_id = we.wip_entity_id
985: AND wmt.transaction_date BETWEEN
986: TRUNC(p_start_date) AND
987: (TRUNC(p_end_date) + 0.99999)