APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_INSTANCE_TEMP

Line 107: --| OKS_INSTANCE_TEMP | X | | | | | |

103: --| OKC_K_LINES_V | X | | | | | |
104: --+---------------------------------+---+---+---+---+---+----------------------+
105: --| OKC_K_PARTY_ROLES_B | X | | | | | |
106: --+---------------------------------+---+---+---+---+---+----------------------+
107: --| OKS_INSTANCE_TEMP | X | | | | | |
108: --+---------------------------------+---+---+---+---+---+----------------------+
109: --| OKC_STATUSES_V | X | | | | | |
110: --+---------------------------------+---+---+---+---+---+----------------------+
111: --| OKC_STATUSES_B | X | | | | | |

Line 6145: oks_instance_temp tmp,

6141: okc_statuses_b Hst,
6142: oks_k_lines_b ks1,
6143: oks_k_lines_b ks2,
6144: okc_k_lines_b kl2,
6145: oks_instance_temp tmp,
6146: okc_k_party_roles_b party
6147: WHERE ki.object1_id1 = to_char(tmp.old_customer_product_id)
6148: AND tmp.trf = 'Y'
6149: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 6236: oks_instance_temp tmp,

6232: oks_k_lines_b okl,
6233: oks_k_lines_b okl1,
6234: okc_statuses_b st,
6235: okc_k_party_roles_b party,
6236: oks_instance_temp tmp,
6237: okc_statuses_b Hst
6238: WHERE tmp.trf = 'Y'
6239: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6240: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 6311: oks_instance_temp tmp,

6307: FROM okc_k_items ki,
6308: okc_k_headers_all_b kh,
6309: okc_k_lines_b kl,
6310: okc_statuses_b st,
6311: oks_instance_temp tmp,
6312: okc_k_lines_b tl,
6313: okc_k_party_roles_b party,
6314: Okc_statuses_b Hst,
6315: Okc_statuses_b Lst

Line 6377: oks_instance_temp tmp,

6373: okc_k_lines_b kl,
6374: okc_k_lines_b tl,
6375: okc_statuses_b st,
6376: csi_counter_associations ctrAsc,
6377: oks_instance_temp tmp,
6378: okc_k_party_roles_b party,
6379: okc_statuses_b Hst,
6380: okc_statuses_b Lst
6381: WHERE tmp.trm = 'Y'

Line 6444: oks_instance_temp tmp,

6440: FROM okc_k_items ki,
6441: okc_k_headers_all_b kh,
6442: okc_k_lines_b kl,
6443: okc_statuses_b st,
6444: oks_instance_temp tmp,
6445: okc_k_lines_b tl,
6446: oks_k_lines_v ksl,
6447: oks_k_lines_b ks11
6448: WHERE tmp.idc = 'Y'

Line 6544: oks_instance_temp c

6540: SELECT DISTINCT a.relationship_type
6541: FROM hz_relationships a,
6542: hz_cust_accounts b1,
6543: hz_cust_accounts b2,
6544: oks_instance_temp c
6545: WHERE ( ( a.object_id = b1.party_id
6546: AND a.subject_id = b2.party_id
6547: )
6548: OR ( a.object_id = b2.party_id

Line 7204: FROM oks_instance_temp a,

7200: fnd_global.user_id,
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 ');

Line 7730: FROM oks_instance_temp a,

7726: fnd_global.user_id,
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;

Line 8564: FROM oks_instance_temp a,

8560: fnd_global.user_id,
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');