DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on WIP_MOVE_TXN_INTERFACE

Line 754: INSERT INTO wip_move_txn_interface(

750: FROM dual;
751:
752: l_total_row := p_move_table_pvt.count;
753: FOR i IN 1..l_total_row LOOP
754: INSERT INTO wip_move_txn_interface(
755: group_id,
756: transaction_id,
757: last_update_date,
758: last_updated_by,

Line 909: FROM wip_move_txn_interface wmti,

905: wmti.request_id,
906: wmti.program_application_id,
907: wmti.program_id,
908: wmti.program_update_date
909: FROM wip_move_txn_interface wmti,
910: mtl_serial_numbers msn,
911: wip_discrete_jobs wdj
912: WHERE wmti.transaction_id = l_txn_id
913: AND wmti.group_id = x_group_id

Line 980: wip_move_txn_interface wmti

976: CURSOR c_errors IS
977: SELECT wtie.error_column,
978: wtie.error_message
979: FROM wip_txn_interface_errors wtie,
980: wip_move_txn_interface wmti
981: WHERE wtie.transaction_id = wmti.transaction_id
982: AND wmti.group_id = p_group_id;
983:
984: CURSOR c_move_intf_records IS

Line 988: FROM wip_move_txn_interface wmti

984: CURSOR c_move_intf_records IS
985: SELECT wmti.wip_entity_id wip_id,
986: wmti.fm_operation_seq_num fm_op,
987: wmti.to_operation_seq_num to_op
988: FROM wip_move_txn_interface wmti
989: WHERE wmti.group_id = p_group_id
990: ORDER BY wmti.transaction_id;
991:
992: l_log_level NUMBER := fnd_log.g_current_runtime_level;