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 7205: csi_item_instances b

7201: SYSDATE,
7202: fnd_global.login_id,
7203: p_batch_id
7204: FROM oks_instance_temp a,
7205: csi_item_instances b
7206: WHERE a.old_customer_product_id = b.instance_id);
7207:
7208: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History Created ');
7209: --Set Variable to identify Instance history record is created to avoid duplicates.

Line 7731: csi_item_instances b

7727: SYSDATE,
7728: fnd_global.login_id,
7729: p_batch_id
7730: FROM oks_instance_temp a,
7731: csi_item_instances b
7732: WHERE a.old_customer_product_id = b.instance_id);
7733:
7734: End If;
7735: -- create instance history details

Line 8230: csi_item_instances b

8226: SYSDATE,
8227: fnd_global.login_id,
8228: p_batch_id
8229: FROM oks_instance_k_dtls_temp a,
8230: csi_item_instances b
8231: WHERE a.instance_id = b.instance_id);
8232:
8233: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8234:

Line 8565: csi_item_instances b

8561: SYSDATE,
8562: fnd_global.login_id,
8563: p_batch_id
8564: FROM oks_instance_temp a,
8565: csi_item_instances b
8566: WHERE a.old_customer_product_id = b.instance_id);
8567:
8568: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8569: