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_CUSTOMER_ACCOUNTS_V

Line 80: OKX_CUSTOMER_ACCOUNTS_V CA1

76: CURSOR l_csr_rel_party (p_party_id IN NUMBER,
77: p_org_id IN NUMBER) IS
78: SELECT P.id1, P.name
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

Line 84: OKX_CUSTOMER_ACCOUNTS_V B

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'
88: AND A.status = 'A'

Line 100: OKX_CUSTOMER_ACCOUNTS_V CA1

96: WHERE id1 = p_party_id
97: UNION
98: SELECT P.id1, p.name
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

Line 104: OKX_CUSTOMER_ACCOUNTS_V B

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'
108: AND A.status = 'A'

Line 179: FROM OKX_CUSTOMER_ACCOUNTS_V CA1

175: CURSOR l_csr_customer (p_party_id IN NUMBER,
176: p_org_id IN NUMBER)
177: IS
178: SELECT CA1.Id1, CA1.name
179: FROM OKX_CUSTOMER_ACCOUNTS_V CA1
180: WHERE CA1.party_id = p_party_id
181: AND CA1.status = 'A'
182: ORDER BY ca1.name ;
183:

Line 188: FROM OKX_CUSTOMER_ACCOUNTS_V CA2

184:
185: CURSOR l_csr_rel_customer (p_party_id IN NUMBER,
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

Line 191: OKX_CUSTOMER_ACCOUNTS_V B

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'
195: AND A.status = 'A'

Line 203: FROM OKX_CUSTOMER_ACCOUNTS_V CA1

199:
200: CURSOR l_csr_both_customer(p_party_id IN NUMBER,
201: p_org_id IN NUMBER) IS
202: SELECT CA1.Id1, CA1.name
203: FROM OKX_CUSTOMER_ACCOUNTS_V CA1
204: WHERE CA1.party_id = p_party_id
205: AND CA1.status = 'A'
206: UNION
207: SELECT CA2.id1, CA2.name

Line 208: FROM OKX_CUSTOMER_ACCOUNTS_V CA2

204: WHERE CA1.party_id = p_party_id
205: AND CA1.status = '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

Line 211: OKX_CUSTOMER_ACCOUNTS_V B

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'
215: AND A.status = 'A'

Line 221: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;

217: AND CA2.status = 'A'
218: ORDER BY 2 ;
219:
220: i NUMBER := 1;
221: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
222: l_customer_name OKX_CUSTOMER_ACCOUNTS_V.name%TYPE;
223:
224: BEGIN
225: --------------------------------errorout(' IN customer id func '||p_default||' '||p_party_id||' '||p_org_id);

Line 222: l_customer_name OKX_CUSTOMER_ACCOUNTS_V.name%TYPE;

218: ORDER BY 2 ;
219:
220: i NUMBER := 1;
221: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
222: l_customer_name OKX_CUSTOMER_ACCOUNTS_V.name%TYPE;
223:
224: BEGIN
225: --------------------------------errorout(' IN customer id func '||p_default||' '||p_party_id||' '||p_org_id);
226:

Line 304: (SELECT id1 FROM okx_customer_accounts_v

300: CII.last_oe_order_line_id
301: FROM CSI_ITEM_INSTANCES CII,
302: CSI_INSTANCE_STATUSES CIS
303: WHERE CII.owner_party_account_id IN
304: (SELECT id1 FROM okx_customer_accounts_v
305: WHERE party_id = p_party_id)
306: AND CII.Instance_status_id = CIS.instance_status_id
307: AND CIS.service_order_allowed_flag = 'Y';
308:

Line 320: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE ;

316: l_prod_rec prod_rec;
317: l_id NUMBER;
318: i NUMBER := 1;
319: l_add_condition_sql VARCHAR2(500) := '';
320: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE ;
321: l_org_id NUMBER;get_prod_sql_all VARCHAR2(5000);
322: l_order_by VARCHAR2(2000);
323: get_prod_sql_cust VARCHAR2(10000);
324: get_prod_sql_rel VARCHAR2(10000);

Line 371: ||' from okx_customer_accounts_v '

367: ||' AND IT.organization_id = :p_organization_id '
368: ||' AND CIS.instance_status_id = CII.instance_status_id '
369: ||' AND CIS.service_order_allowed_flag = ''Y'''
370: ||' AND CII.owner_party_account_id in (select id1 '
371: ||' from okx_customer_accounts_v '
372: ||' where party_id = :l_party_id ) ';
373:
374:
375: /**** Get products when default = related ***/

Line 398: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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'''
402: ||' AND A.status = ''A'''

Line 427: ||' from okx_customer_accounts_v '

423: ||' AND '
424: ||' CIS.instance_status_id = CII.instance_status_id '
425: ||' AND CIS.service_order_allowed_flag = ''Y'''
426: ||' AND CII.owner_party_account_id in (select id1 '
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, '

Line 432: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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'
436: ||' AND B.status = ''A'''

Line 844: FROM okx_customer_accounts_v

840: (SELECT instance_id
841: FROM csi_item_instances
842: WHERE inventory_item_id = p_inventory_id
843: AND owner_party_account_id IN (SELECT id1
844: FROM okx_customer_accounts_v
845: WHERE party_id = p_party_id)))
846: CONNECT BY ciir.object_id = PRIOR ciir.subject_id ;
847:
848: /** Cursor to get product + system item details for select instance id ***/

Line 920: ||' from okx_customer_accounts_v '

916: ||' ( SELECT instance_id '
917: ||' FROM csi_item_instances '
918: ||' WHERE inventory_item_id = to_char(:l_id)'
919: ||' AND owner_party_account_id in (select id1 '
920: ||' from okx_customer_accounts_v '
921: ||' where party_id = to_char(:p_party_id) ))) '
922: ||'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ' ;
923:
924:

Line 940: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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'''
944: ||' AND A.status = ''A'''

Line 962: ||' from okx_customer_accounts_v '

958: ||' ( SELECT instance_id '
959: ||' FROM csi_item_instances '
960: ||' WHERE inventory_item_id = to_char(:l_id)'
961: ||' AND owner_party_account_id in (select id1 '
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, '

Line 967: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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'''
971: ||' AND A.status = ''A'''

Line 1434: ||' FROM okx_customer_accounts_v '

1430:
1431: l_item_cust := ' from mtl_system_items_kfv '
1432: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '
1433: ||' where owner_party_account_id in (select id1 '
1434: ||' FROM okx_customer_accounts_v '
1435: ||' WHERE party_id = :l_party_id)) '
1436: ||' and organization_id = :l_organization_id '
1437: ||' and serviceable_product_flag = ''Y''';
1438:

Line 1443: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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'''
1447: ||' AND A.status = ''A'''

Line 1456: ||' FROM okx_customer_accounts_v '

1452:
1453: l_item_both := ' from mtl_system_items_kfv '
1454: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '
1455: ||' where owner_party_account_id in (select id1 '
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, '

Line 1461: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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'''
1465: ||' AND A.status = ''A'''

Line 2443: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

2439:
2440: CURSOR l_csr_get_customer(p_party_id IN NUMBER ) IS
2441: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2442: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2443: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2444: OKX_PARTIES_V parties
2445: WHERE cust_acc.party_id = p_party_id
2446: AND cust_acc.party_id = parties.id1
2447: AND cust_acc.status = 'A';

Line 2457: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

2453:
2454: CURSOR l_csr_get_all_customers IS
2455: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2456: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2457: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2458: OKX_PARTIES_V parties
2459: WHERE cust_acc.party_id = parties.id1
2460: AND cust_acc.status = 'A';
2461:

Line 2624: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

2620:
2621: CURSOR l_csr_party_related(p_party_id IN NUMBER,
2622: p_org_id IN NUMBER) IS
2623: SELECT P1.id1, P1.id2, P1.name, P1.description
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

Line 2627: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

2623: SELECT P1.id1, P1.id2, P1.name, P1.description
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'

Line 2645: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

2641: WHERE id1 = p_party_id
2642: AND status = 'A'
2643: UNION
2644: SELECT P1.id1, P1.id2, P1.name, P1.description
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

Line 2648: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

2644: SELECT P1.id1, P1.id2, P1.name, P1.description
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'

Line 3005: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc

3001: CURSOR l_csr_get_cust_system(p_customer_id IN NUMBER ) IS
3002: SELECT cust_acc.id1, cust_acc.name,
3003: CSB.system_id, '#' id2, CSB.system_number,
3004: CST.description, CST.name system_name
3005: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3006: WHERE cust_acc.id1 = p_customer_id
3007: AND CSB.system_id = CST.system_id
3008: AND CSB.Customer_id = cust_acc.id1
3009: AND CST.language = userenv('lang') -- new

Line 3019: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc

3015: CURSOR l_csr_get_all_cust_system IS
3016: SELECT cust_acc.id1, cust_acc.name,
3017: CSB.system_id, '#' id2, CSB.system_number,
3018: CST.description, CST.name system_name
3019: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3020: WHERE CSB.system_id = CST.system_id
3021: AND CSB.Customer_id = cust_acc.id1
3022: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3023: AND CST.language = userenv('lang') -- new

Line 3034: OKX_CUSTOMER_ACCOUNTS_V cust_acc

3030: CST.name system_name, CST.description, CSB.system_number
3031: FROM CSI_SYSTEMS_B CSB,
3032: CSI_SYSTEMS_TL CST,
3033: OKX_PARTIES_V parties,
3034: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3035: WHERE parties.id1 = p_party_id
3036: AND cust_acc.party_id = parties.id1
3037: AND CSB.system_id = CST.system_id
3038: AND CSB.customer_id = cust_acc.id1

Line 3050: OKX_CUSTOMER_ACCOUNTS_V cust_acc

3046: CSB.system_number
3047: FROM CSI_SYSTEMS_B CSB,
3048: CSI_SYSTEMS_TL CST,
3049: OKX_PARTIES_V parties,
3050: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3051: WHERE cust_acc.party_id = parties.id1
3052: AND CSB.system_id = CST.system_id
3053: AND CSB.customer_id = cust_acc.id1
3054: AND CST.language = userenv('lang') -- new

Line 3098: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;

3094: l_csr_system_rec l_csr_get_cust_system%ROWTYPE;
3095:
3096: l_default VARCHAR2(15);
3097: l_party_id NUMBER(15);
3098: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
3099: i NUMBER ;
3100: rowcount NUMBER := 1;
3101: l_org_id NUMBER ;
3102: l_party_id_tbl party_id_tbl;

Line 5659: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;

5655: l_party_id NUMBER;
5656: l_uom OKC_K_ITEMS.uom_code%TYPE;
5657: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
5658: l_rgp_id OKC_RULE_GROUPS_B.id%TYPE;
5659: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
5660:
5661:
5662: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
5663: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;