DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on CSI_ITEM_INSTANCES

Line 135: --| CSI_ITEM_INSTANCES | X | | | | | |

131: --| OKS_IHD_PVT | | | | | |X |
132: --+---------------------------------+---+---+---+---+---+----------------------+
133: --| OKS_INS_PVT | | | | | |X |
134: --+---------------------------------+---+---+---+---+---+----------------------+
135: --| CSI_ITEM_INSTANCES | X | | | | | |
136: --+---------------------------------+---+---+---+---+---+----------------------+
137: --| OKS_INST_HIST_DETAILS | | X | | | | |
138: --+---------------------------------+---+---+---+---+---+----------------------+
139:

Line 7188: csi_item_instances b

7184: SYSDATE,
7185: fnd_global.login_id,
7186: p_batch_id
7187: FROM oks_instance_temp a,
7188: csi_item_instances b
7189: WHERE a.old_customer_product_id = b.instance_id);
7190:
7191: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Created ');
7192: --Set Variable to identify Instance history record is created to avoid duplicates.

Line 7714: csi_item_instances b

7710: SYSDATE,
7711: fnd_global.login_id,
7712: p_batch_id
7713: FROM oks_instance_temp a,
7714: csi_item_instances b
7715: WHERE a.old_customer_product_id = b.instance_id);
7716:
7717: End If;
7718: -- create instance history details

Line 8190: csi_item_instances b

8186: SYSDATE,
8187: fnd_global.login_id,
8188: p_batch_id
8189: FROM oks_instance_k_dtls_temp a,
8190: csi_item_instances b
8191: WHERE a.instance_id = b.instance_id);
8192:
8193: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8194:

Line 8522: csi_item_instances b

8518: SYSDATE,
8519: fnd_global.login_id,
8520: p_batch_id
8521: FROM oks_instance_temp a,
8522: csi_item_instances b
8523: WHERE a.old_customer_product_id = b.instance_id);
8524:
8525: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8526: