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 1022: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

1018: ||' FROM csi_item_instances '
1019: ||' WHERE inventory_item_id = to_char(:l_id ) '
1020: ||' AND owner_party_account_id in '
1021: ||' (select A.RELATED_CUST_ACCOUNT_ID '
1022: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
1023: ||' OKX_CUSTOMER_ACCOUNTS_V B '
1024: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
1025: ||' AND B.party_id = to_char(:p_party_id) '
1026: ||' AND B.status = ''A'''

Line 1049: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

1045: ||' from okx_customer_accounts_v '
1046: ||' where party_id = to_char(:p_party_id)) '
1047: ||' UNION '
1048: ||' (select A.RELATED_CUST_ACCOUNT_ID '
1049: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
1050: ||' OKX_CUSTOMER_ACCOUNTS_V B '
1051: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
1052: ||' AND B.party_id = to_char(:p_party_id)'
1053: ||' AND B.status = ''A'''

Line 1560: ' FROM OKX_CUST_ACCT_RELATE_ALL_V A, ' ||

1556: ' FROM csi_item_instances ' ||
1557: ' WHERE instance_id = to_char(:l_id ) ' ||
1558: ' AND owner_party_account_id in ' ||
1559: ' (select A.RELATED_CUST_ACCOUNT_ID ' ||
1560: ' FROM OKX_CUST_ACCT_RELATE_ALL_V A, ' ||
1561: ' OKX_CUSTOMER_ACCOUNTS_V B ' ||
1562: ' WHERE B.ID1 = A.CUST_ACCOUNT_ID ' ||
1563: ' AND B.party_id = to_char(:p_party_id) ' ||
1564: ' AND B.status = ''A''' ||

Line 1583: ' FROM OKX_CUST_ACCT_RELATE_ALL_V A, ' ||

1579: ' AND owner_party_account_id in ((select id1 ' ||
1580: ' from okx_customer_accounts_v ' ||
1581: ' where party_id = to_char(:p_party_id)) ' || ' UNION ' ||
1582: ' (select A.RELATED_CUST_ACCOUNT_ID ' ||
1583: ' FROM OKX_CUST_ACCT_RELATE_ALL_V A, ' ||
1584: ' OKX_CUSTOMER_ACCOUNTS_V B ' ||
1585: ' WHERE B.ID1 = A.CUST_ACCOUNT_ID ' ||
1586: ' AND B.party_id = to_char(:p_party_id)' ||
1587: ' AND B.status = ''A''' ||

Line 1970: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

1966:
1967: l_item_rel := ' FROM mtl_system_items_kfv '
1968: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '
1969: ||' where owner_party_account_id in (select A.RELATED_CUST_ACCOUNT_ID '
1970: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
1971: ||' OKX_CUSTOMER_ACCOUNTS_V B '
1972: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
1973: ||' AND B.party_id = :l_party_id '
1974: ||' AND B.status = ''A'''

Line 1988: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '

1984: ||' FROM okx_customer_accounts_v '
1985: ||' WHERE party_id = :p_party_id '
1986: ||' UNION '
1987: ||' select A.RELATED_CUST_ACCOUNT_ID '
1988: ||' FROM OKX_CUST_ACCT_RELATE_ALL_V A, '
1989: ||' OKX_CUSTOMER_ACCOUNTS_V B '
1990: ||' WHERE B.ID1 = A.CUST_ACCOUNT_ID '
1991: ||' AND B.party_id = :l_party_id '
1992: ||' AND B.status = ''A'''

Line 3168: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

3164: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
3165: WHERE P1.id1 = CA1.party_id
3166: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
3167: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
3168: OKX_CUST_ACCT_RELATE_ALL_V rel_acc
3169: WHERE rel_acc.related_cust_account_id = cust_acc.id1
3170: AND cust_acc.party_id = p_party_id
3171: AND cust_acc.status = 'A'
3172: AND rel_acc.org_id = p_org_id

Line 3189: OKX_CUST_ACCT_RELATE_ALL_V rel_acc

3185: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1
3186: WHERE P1.id1 = CA1.party_id
3187: AND CA1.id1 IN (SELECT rel_acc.cust_account_id
3188: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
3189: OKX_CUST_ACCT_RELATE_ALL_V rel_acc
3190: WHERE rel_acc.related_cust_account_id = cust_acc.id1
3191: AND cust_acc.party_id = p_party_id
3192: AND cust_acc.status = 'A'
3193: AND rel_acc.org_id = p_org_id