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 6128: oks_instance_temp tmp,

6124: okc_statuses_b Hst,
6125: oks_k_lines_b ks1,
6126: oks_k_lines_b ks2,
6127: okc_k_lines_b kl2,
6128: oks_instance_temp tmp,
6129: okc_k_party_roles_b party
6130: WHERE ki.object1_id1 = to_char(tmp.old_customer_product_id)
6131: AND tmp.trf = 'Y'
6132: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 6219: oks_instance_temp tmp,

6215: oks_k_lines_b okl,
6216: oks_k_lines_b okl1,
6217: okc_statuses_b st,
6218: okc_k_party_roles_b party,
6219: oks_instance_temp tmp,
6220: okc_statuses_b Hst
6221: WHERE tmp.trf = 'Y'
6222: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6223: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 6294: oks_instance_temp tmp,

6290: FROM okc_k_items ki,
6291: okc_k_headers_all_b kh,
6292: okc_k_lines_b kl,
6293: okc_statuses_b st,
6294: oks_instance_temp tmp,
6295: okc_k_lines_b tl,
6296: okc_k_party_roles_b party,
6297: Okc_statuses_b Hst,
6298: Okc_statuses_b Lst

Line 6360: oks_instance_temp tmp,

6356: okc_k_lines_b kl,
6357: okc_k_lines_b tl,
6358: okc_statuses_b st,
6359: csi_counter_associations ctrAsc,
6360: oks_instance_temp tmp,
6361: okc_k_party_roles_b party,
6362: okc_statuses_b Hst,
6363: okc_statuses_b Lst
6364: WHERE tmp.trm = 'Y'

Line 6427: oks_instance_temp tmp,

6423: FROM okc_k_items ki,
6424: okc_k_headers_all_b kh,
6425: okc_k_lines_b kl,
6426: okc_statuses_b st,
6427: oks_instance_temp tmp,
6428: okc_k_lines_b tl,
6429: oks_k_lines_v ksl,
6430: oks_k_lines_b ks11
6431: WHERE tmp.idc = 'Y'

Line 6527: oks_instance_temp c

6523: SELECT DISTINCT a.relationship_type
6524: FROM hz_relationships a,
6525: hz_cust_accounts b1,
6526: hz_cust_accounts b2,
6527: oks_instance_temp c
6528: WHERE ( ( a.object_id = b1.party_id
6529: AND a.subject_id = b2.party_id
6530: )
6531: OR ( a.object_id = b2.party_id

Line 7187: FROM oks_instance_temp a,

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

Line 7713: FROM oks_instance_temp a,

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

Line 8521: FROM oks_instance_temp a,

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