DBA Data[Home] [Help]

APPS.WIP_BATCH_MOVE dependencies on WIP_MOVE_TXN_INTERFACE

Line 865: INSERT INTO wip_move_txn_interface(

861: FROM dual;
862:
863: l_total_row := p_move_table_pvt.count;
864: FOR i IN 1..l_total_row LOOP
865: INSERT INTO wip_move_txn_interface(
866: group_id,
867: transaction_id,
868: last_update_date,
869: last_updated_by,

Line 1020: FROM wip_move_txn_interface wmti,

1016: wmti.request_id,
1017: wmti.program_application_id,
1018: wmti.program_id,
1019: wmti.program_update_date
1020: FROM wip_move_txn_interface wmti,
1021: mtl_serial_numbers msn,
1022: wip_discrete_jobs wdj
1023: WHERE wmti.transaction_id = l_txn_id
1024: AND wmti.group_id = x_group_id

Line 1091: wip_move_txn_interface wmti

1087: CURSOR c_errors IS
1088: SELECT wtie.error_column,
1089: wtie.error_message
1090: FROM wip_txn_interface_errors wtie,
1091: wip_move_txn_interface wmti
1092: WHERE wtie.transaction_id = wmti.transaction_id
1093: AND wmti.group_id = p_group_id;
1094:
1095: CURSOR c_move_intf_records IS

Line 1099: FROM wip_move_txn_interface wmti

1095: CURSOR c_move_intf_records IS
1096: SELECT wmti.wip_entity_id wip_id,
1097: wmti.fm_operation_seq_num fm_op,
1098: wmti.to_operation_seq_num to_op
1099: FROM wip_move_txn_interface wmti
1100: WHERE wmti.group_id = p_group_id
1101: ORDER BY wmti.transaction_id;
1102:
1103: l_log_level NUMBER := fnd_log.g_current_runtime_level;