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 927: FROM okx_customer_accounts_v

923: (SELECT instance_id
924: FROM csi_item_instances
925: WHERE inventory_item_id = p_inventory_id
926: AND owner_party_account_id IN (SELECT id1
927: FROM okx_customer_accounts_v
928: WHERE party_id = p_party_id)))
929: CONNECT BY ciir.object_id = PRIOR ciir.subject_id ;
930:
931: /** Cursor to get product + system item details for select instance id ***/

Line 1003: ||' from okx_customer_accounts_v '

999: ||' ( SELECT instance_id '
1000: ||' FROM csi_item_instances '
1001: ||' WHERE inventory_item_id = to_char(:l_id)'
1002: ||' AND owner_party_account_id in (select id1 '
1003: ||' from okx_customer_accounts_v '
1004: ||' where party_id = to_char(:p_party_id) ))) '
1005: ||'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ' ;
1006:
1007:

Line 1023: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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

Line 1045: ||' from okx_customer_accounts_v '

1041: ||' ( SELECT instance_id '
1042: ||' FROM csi_item_instances '
1043: ||' WHERE inventory_item_id = to_char(:l_id)'
1044: ||' AND owner_party_account_id in (select id1 '
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, '

Line 1050: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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

Line 1427: FROM okx_customer_accounts_v

1423: FROM csi_item_instances
1424: WHERE inventory_item_id = p_inventory_id
1425: AND owner_party_account_id IN
1426: (SELECT id1
1427: FROM okx_customer_accounts_v
1428: WHERE party_id = p_party_id)))
1429: CONNECT BY ciir.object_id = PRIOR ciir.subject_id;
1430:
1431: /** Cursor to get product + system item details for select instance id ***/

Line 1544: ' from okx_customer_accounts_v ' ||

1540: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1541: ' FROM csi_item_instances ' ||
1542: ' WHERE instance_id = to_char(:l_id)' ||
1543: ' AND owner_party_account_id in (select id1 ' ||
1544: ' from okx_customer_accounts_v ' ||
1545: ' where party_id = to_char(:p_party_id) ))) ' ||
1546: 'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ';
1547:
1548: l_config_rel := 'SELECT ciir.object_id config_parent_id,' ||

Line 1561: ' OKX_CUSTOMER_ACCOUNTS_V B ' ||

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

Line 1580: ' from okx_customer_accounts_v ' ||

1576: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1577: ' FROM csi_item_instances ' ||
1578: ' WHERE instance_id = to_char(:l_id)' ||
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 ' ||

Line 1584: ' OKX_CUSTOMER_ACCOUNTS_V B ' ||

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

Line 1962: ||' FROM okx_customer_accounts_v '

1958:
1959: l_item_cust := ' from mtl_system_items_kfv '
1960: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '
1961: ||' where owner_party_account_id in (select id1 '
1962: ||' FROM okx_customer_accounts_v '
1963: ||' WHERE party_id = :l_party_id)) '
1964: ||' and organization_id = :l_organization_id '
1965: ||' and serviceable_product_flag = ''Y''';
1966:

Line 1971: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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

Line 1984: ||' FROM okx_customer_accounts_v '

1980:
1981: l_item_both := ' from mtl_system_items_kfv '
1982: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '
1983: ||' where owner_party_account_id in (select id1 '
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, '

Line 1989: ||' OKX_CUSTOMER_ACCOUNTS_V B '

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

Line 2983: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

2979:
2980: CURSOR l_csr_get_customer(p_party_id IN NUMBER ) IS
2981: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2982: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2983: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2984: OKX_PARTIES_V parties
2985: WHERE cust_acc.party_id = p_party_id
2986: AND cust_acc.party_id = parties.id1
2987: AND cust_acc.status = 'A';

Line 2997: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

2993:
2994: CURSOR l_csr_get_all_customers IS
2995: SELECT cust_acc.party_id party_id, parties.name party_name, parties.description description,
2996: cust_acc.id1 id1, cust_acc.name name, cust_acc.id2 id2, cust_acc.description account_number
2997: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,
2998: OKX_PARTIES_V parties
2999: WHERE cust_acc.party_id = parties.id1
3000: AND cust_acc.status = 'A';
3001:

Line 3164: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

3160:
3161: CURSOR l_csr_party_related(p_party_id IN NUMBER,
3162: p_org_id IN NUMBER) IS
3163: SELECT P1.id1, P1.id2, P1.name, P1.description
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

Line 3167: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

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

Line 3185: FROM OKX_PARTIES_V P1, OKX_CUSTOMER_ACCOUNTS_V CA1

3181: WHERE id1 = p_party_id
3182: AND status = 'A'
3183: UNION
3184: SELECT P1.id1, P1.id2, P1.name, P1.description
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

Line 3188: FROM OKX_CUSTOMER_ACCOUNTS_V cust_acc,

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

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

3541: CURSOR l_csr_get_cust_system(p_customer_id IN NUMBER ) IS
3542: SELECT cust_acc.id1, cust_acc.name,
3543: CSB.system_id, '#' id2, CSB.system_number,
3544: CST.description, CST.name system_name
3545: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3546: WHERE cust_acc.id1 = p_customer_id
3547: AND CSB.system_id = CST.system_id
3548: AND CSB.Customer_id = cust_acc.id1
3549: AND CST.language = userenv('lang') -- new

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

3555: CURSOR l_csr_get_all_cust_system IS
3556: SELECT cust_acc.id1, cust_acc.name,
3557: CSB.system_id, '#' id2, CSB.system_number,
3558: CST.description, CST.name system_name
3559: FROM CSI_SYSTEMS_B CSB, CSI_SYSTEMS_TL CST, OKX_CUSTOMER_ACCOUNTS_V cust_acc
3560: WHERE CSB.system_id = CST.system_id
3561: AND CSB.Customer_id = cust_acc.id1
3562: AND SYSDATE BETWEEN NVL(CSB.start_date_active, SYSDATE) AND NVL(CSB.end_date_active, SYSDATE)
3563: AND CST.language = userenv('lang') -- new

Line 3574: OKX_CUSTOMER_ACCOUNTS_V cust_acc

3570: CST.name system_name, CST.description, CSB.system_number
3571: FROM CSI_SYSTEMS_B CSB,
3572: CSI_SYSTEMS_TL CST,
3573: OKX_PARTIES_V parties,
3574: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3575: WHERE parties.id1 = p_party_id
3576: AND cust_acc.party_id = parties.id1
3577: AND CSB.system_id = CST.system_id
3578: AND CSB.customer_id = cust_acc.id1

Line 3590: OKX_CUSTOMER_ACCOUNTS_V cust_acc

3586: CSB.system_number
3587: FROM CSI_SYSTEMS_B CSB,
3588: CSI_SYSTEMS_TL CST,
3589: OKX_PARTIES_V parties,
3590: OKX_CUSTOMER_ACCOUNTS_V cust_acc
3591: WHERE cust_acc.party_id = parties.id1
3592: AND CSB.system_id = CST.system_id
3593: AND CSB.customer_id = cust_acc.id1
3594: AND CST.language = userenv('lang') -- new

Line 3638: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;

3634: l_csr_system_rec l_csr_get_cust_system%ROWTYPE;
3635:
3636: l_default VARCHAR2(15);
3637: l_party_id NUMBER(15);
3638: l_customer_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
3639: i NUMBER ;
3640: rowcount NUMBER := 1;
3641: l_org_id NUMBER ;
3642: l_party_id_tbl party_id_tbl;

Line 6273: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;

6269: l_party_id NUMBER;
6270: l_uom OKC_K_ITEMS.uom_code%TYPE;
6271: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
6272: l_rgp_id OKC_RULE_GROUPS_B.id%TYPE;
6273: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
6274:
6275:
6276: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%TYPE;
6277: l_revision MTL_ITEM_REVISIONS_VL.revision%TYPE;