DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on CSI_I_ASSET_INTERFACE

Line 84: FROM csi_i_asset_interface a

80: nvl(p_source_system_name,source_system_name));
81:
82: CURSOR asst_intf_cur IS
83: SELECT ia_interface_id
84: FROM csi_i_asset_interface a
85: WHERE a.inst_interface_id IN (SELECT inst_interface_id
86: FROM csi_instance_interface cii
87: WHERE cii.transaction_identifier IS NOT NULL
88: AND trunc(source_transaction_date)

Line 416: UPDATE csi_i_asset_interface a

412: asst_intf_id_upd
413: LIMIT max_buffer_size;
414:
415: FORALL asst1 in 1 .. asst_intf_id_upd.count
416: UPDATE csi_i_asset_interface a
417: SET a.fa_asset_id = (SELECT asset_id
418: FROM fa_additions_b
419: WHERE asset_number =
420: a.fa_asset_number

Line 610: FROM csi_i_asset_interface a

606: AND parallel_worker_id = p_worker_id);
607:
608: CURSOR asst_intf_cur IS
609: SELECT ia_interface_id
610: FROM csi_i_asset_interface a
611: WHERE a.inst_interface_id IN (SELECT inst_interface_Id
612: FROM csi_instance_interface
613: WHERE transaction_identifier IS NULL
614: AND trunc(source_transaction_date)

Line 939: UPDATE csi_i_asset_interface a

935: asst_intf_id_upd
936: LIMIT max_buffer_size;
937:
938: FORALL asst1 in 1 .. asst_intf_id_upd.count
939: UPDATE csi_i_asset_interface a
940: SET a.fa_asset_id = (SELECT asset_id
941: FROM fa_additions_b
942: WHERE asset_number =
943: a.fa_asset_number