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 984: FROM wip_move_transactions wmt

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

Line 1980: wip_move_transactions wmt

1976: wmt.to_operation_seq_num to_op_seq,
1977: wmt.to_intraoperation_step_type to_op_step,
1978: wmt.primary_quantity pri_qty
1979: FROM cst_cost_group_assignments ccga,
1980: wip_move_transactions wmt
1981: WHERE wmt.transaction_date BETWEEN TRUNC(p_start_date)
1982: AND (TRUNC(p_end_date) + 0.99999)
1983: AND wmt.organization_id = ccga.organization_id
1984: AND ccga.cost_group_id = p_cost_group_id