eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AUTH_UTIL_PVT dependencies on OKX_CUST_ACCT_RELATE_ALL_V

Line 83: FROM OKX_CUST_ACCT_RELATE_ALL_V A,

79: FROM OKX_PARTIES_V P,
80: OKX_CUSTOMER_ACCOUNTS_V CA1
81: WHERE P.id1 = CA1.party_id
82: AND CA1.id1 IN(SELECT A.related_cust_account_id
83: FROM OKX_CUST_ACCT_RELATE_ALL_V A,
84: OKX_CUSTOMER_ACCOUNTS_V B
85: WHERE B.ID1 = A.CUST_ACCOUNT_ID
86: AND B.party_id = p_party_id
87: AND B.status = 'A'

Line 103: FROM OKX_CUST_ACCT_RELATE_ALL_V A,

99: FROM OKX_PARTIES_V P,
100: OKX_CUSTOMER_ACCOUNTS_V CA1
101: WHERE P.id1 = CA1.party_id
102: AND CA1.id1 IN(SELECT A.related_cust_account_id
103: FROM OKX_CUST_ACCT_RELATE_ALL_V A,
104: OKX_CUSTOMER_ACCOUNTS_V B
105: WHERE B.ID1 = A.CUST_ACCOUNT_ID
106: AND B.party_id = p_party_id
107: AND B.status = 'A'

Line 190: FROM OKX_CUST_ACCT_RELATE_ALL_V A,

186: p_org_id IN NUMBER) IS
187: SELECT CA2.id1, CA2.name
188: FROM OKX_CUSTOMER_ACCOUNTS_V CA2
189: WHERE CA2.id1 IN(SELECT A.RELATED_CUST_ACCOUNT_ID
190: FROM OKX_CUST_ACCT_RELATE_ALL_V A,
191: OKX_CUSTOMER_ACCOUNTS_V B
192: WHERE B.ID1 = A.CUST_ACCOUNT_ID
193: AND B.party_id = p_party_id
194: AND B.status = 'A'

Line 210: FROM OKX_CUST_ACCT_RELATE_ALL_V A,

206: UNION
207: SELECT CA2.id1, CA2.name
208: FROM OKX_CUSTOMER_ACCOUNTS_V CA2
209: WHERE CA2.id1 IN(SELECT A.RELATED_CUST_ACCOUNT_ID
210: FROM OKX_CUST_ACCT_RELATE_ALL_V A,
211: OKX_CUSTOMER_ACCOUNTS_V B
212: WHERE B.ID1 = A.CUST_ACCOUNT_ID
213: AND B.party_id = p_party_id
214: AND B.status = 'A'

Line 397: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

393: ||' CIS.instance_status_id = CII.instance_status_id '
394: ||' AND CIS.service_order_allowed_flag = ''Y'''
395: ||' AND CII.owner_party_account_id in '
396: ||' (select A.RELATED_CUST_ACCOUNT_ID '
397: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
398: ||' OKX_CUSTOMER_ACCOUNTS_V B '
399: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
400: ||' AND B.party_id = :l_party_id '
401: ||' AND B.status = ''A'''

Line 431: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

427: ||' from okx_customer_accounts_v '
428: ||' where party_id = to_char(:l_party_id) '
429: ||' UNION '
430: ||' select A.RELATED_CUST_ACCOUNT_ID '
431: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
432: ||' OKX_CUSTOMER_ACCOUNTS_V B '
433: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
434:
435: ||' AND B.party_id = :l_party_id'

Line 939: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

935: ||' FROM csi_item_instances '
936: ||' WHERE inventory_item_id = to_char(:l_id ) '
937: ||' AND owner_party_account_id in '
938: ||' (select A.RELATED_CUST_ACCOUNT_ID '
939: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
940: ||' OKX_CUSTOMER_ACCOUNTS_V B '
941: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
942: ||' AND B.party_id = to_char(:p_party_id) '
943: ||' AND B.status = ''A'''

Line 966: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

962: ||' from okx_customer_accounts_v '
963: ||' where party_id = to_char(:p_party_id)) '
964: ||' UNION '
965: ||' (select A.RELATED_CUST_ACCOUNT_ID '
966: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
967: ||' OKX_CUSTOMER_ACCOUNTS_V B '
968: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
969: ||' AND B.party_id = to_char(:p_party_id)'
970: ||' AND B.status = ''A'''

Line 1442: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

1438:
1439: l_item_rel := ' FROM mtl_system_items_kfv '
1440: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '
1441: ||' where owner_party_account_id in (select A.RELATED_CUST_ACCOUNT_ID '
1442: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
1443: ||' OKX_CUSTOMER_ACCOUNTS_V B '
1444: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
1445: ||' AND B.party_id = :l_party_id '
1446: ||' AND B.status = ''A'''

Line 1460: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

1456: ||' FROM okx_customer_accounts_v '
1457: ||' WHERE party_id = :p_party_id '
1458: ||' UNION '
1459: ||' select A.RELATED_CUST_ACCOUNT_ID '
1460: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
1461: ||' OKX_CUSTOMER_ACCOUNTS_V B '
1462: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
1463: ||' AND B.party_id = :l_party_id '
1464: ||' AND B.status = ''A'''

Line 2628: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

2624: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
2625: WHERE P1.id1 = CA1.party_id
2626: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
2627: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2628: OKX_CUST_ACCT_RELATE_ALL_V rel_acc
2629: WHERE rel_acc.related_cust_account_id = cust_acc.id1
2630: AND cust_acc.party_id = p_party_id
2631: AND cust_acc.status = 'A'
2632: AND rel_acc.org_id = p_org_id

Line 2649: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

2645: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
2646: WHERE P1.id1 = CA1.party_id
2647: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
2648: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2649: OKX_CUST_ACCT_RELATE_ALL_V rel_acc
2650: WHERE rel_acc.related_cust_account_id = cust_acc.id1
2651: AND cust_acc.party_id = p_party_id
2652: AND cust_acc.status = 'A'
2653: AND rel_acc.org_id = p_org_id