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 CSI_ITEM_INSTANCES

Line 301: FROM CSI_ITEM_INSTANCES CII,

297: CII.inventory_item_id,
298: CII.serial_number,
299: '#' id2,
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)

Line 343: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS '

339: ||', CII.serial_number serial_number '
340: ||', ''#'' id2 '
341: ||', CII.last_oe_order_line_id '
342: ||', CII.external_reference ' -- new bug 4372877
343: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS '
344: ||' WHERE '
345: ||' CIS.instance_status_id = CII.instance_status_id '
346: ||' AND CIS.service_order_allowed_flag = ''Y''' ;
347:

Line 364: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

360: ||', CII.serial_number serial_number '
361: ||', ''#'' id2 '
362: ||', CII.last_oe_order_line_id '
363: ||', CII.external_reference ' -- new bug 4372877
364: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
365: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
366: ||' AND IT.serviceable_product_flag = ''Y'''
367: ||' AND IT.organization_id = :p_organization_id '
368: ||' AND CIS.instance_status_id = CII.instance_status_id '

Line 388: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

384: ||', CII.serial_number serial_number '
385: ||', ''#'' id2 '
386: ||', last_oe_order_line_id '
387: ||', CII.external_reference ' -- new bug 4372877
388: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
389: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
390: ||' AND IT.serviceable_product_flag = ''Y'''
391: ||' AND IT.organization_id = :p_organization_id '
392: ||' AND '

Line 419: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

415: ||', CII.serial_number serial_number '
416: ||', ''#'' id2 '
417: ||', last_oe_order_line_id '
418: ||', CII.external_reference ' -- new bug 4372877
419: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
420: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
421: ||' AND IT.serviceable_product_flag = ''Y'''
422: ||' AND IT.organization_id = :p_organization_id '
423: ||' AND '

Line 453: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

449: ||', CII.serial_number serial_number '
450: ||', ''#'' id2 '
451: ||', CII.last_oe_order_line_id '
452: ||', CII.external_reference ' -- new bug 4372877
453: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
454: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
455: ||' AND IT.serviceable_product_flag = ''Y'''
456: ||' AND IT.organization_id = :p_organization_id '
457: ||' AND '

Line 694: SELECT INSTALL_LOCATION_TYPE_CODE INTO l_install_loc_type FROM csi_item_instances WHERE instance_id=p_instance_id;

690: WHERE hr.LOCATION_ID =p_install_location_id;
691:
692: BEGIN
693:
694: SELECT INSTALL_LOCATION_TYPE_CODE INTO l_install_loc_type FROM csi_item_instances WHERE instance_id=p_instance_id;
695:
696:
697: IF(l_install_loc_type='HZ_PARTY_SITES') THEN
698:

Line 898: csi_item_instances

894: description
895: FROM okx_system_items_v it
896: WHERE id1 IN
897: (SELECT inventory_item_id FROM
898: csi_item_instances
899: WHERE instance_id IN (SELECT PR.object_id
900: FROM csi_ii_relationships PR
901: WHERE relationship_type_code = 'COMPONENT-OF'
902: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp

Line 924: FROM csi_item_instances

920: IN (SELECT ciir_pr.subject_id
921: FROM csi_ii_relationships ciir_pr
922: WHERE object_id IN
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)))

Line 950: FROM CSI_ITEM_INSTANCES CII

946: , CII.serial_number
947: , OOL.unit_selling_price
948: , '#' id2
949: , CII.external_reference -- bug 4372877
950: FROM CSI_ITEM_INSTANCES CII
951: , CSI_INSTANCE_STATUSES CIS
952: , OE_ORDER_LINES_ALL OOL
953: , OKX_SYSTEM_ITEMS_V IT
954: WHERE CII.INSTANCE_ID = p_instance_id

Line 966: l_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE;

962:
963: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := - 99;
964: l_config_rec l_csr_configuration%ROWTYPE;
965: l_model_prod_rec l_csr_model_products%ROWTYPE;
966: l_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE;
967: l_inv_id NUMBER := - 99;
968: l_id_old NUMBER := - 99;
969: rowcount NUMBER := 1;
970: i NUMBER := 1;

Line 1000: ||' FROM csi_item_instances '

996: ||' IN (SELECT ciir_pr.subject_id '
997: ||' FROM csi_ii_relationships ciir_pr '
998: ||' WHERE object_id IN '
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) ))) '

Line 1018: ||' FROM csi_item_instances '

1014: ||' IN (SELECT ciir_pr.subject_id '
1015: ||' FROM csi_ii_relationships ciir_pr '
1016: ||' WHERE object_id IN '
1017: ||' ( SELECT instance_id '
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, '

Line 1042: ||' FROM csi_item_instances '

1038: ||' IN (SELECT ciir_pr.subject_id '
1039: ||' FROM csi_ii_relationships ciir_pr '
1040: ||' WHERE object_id IN '
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)) '

Line 1069: ||' FROM csi_item_instances '

1065: ||' IN (SELECT ciir_pr.subject_id '
1066: ||' FROM csi_ii_relationships ciir_pr '
1067: ||' WHERE object_id IN '
1068: ||' ( SELECT instance_id '
1069: ||' FROM csi_item_instances '
1070: ||' WHERE inventory_item_id = to_char(:l_id))) '
1071: ||'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ' ;
1072:
1073:

Line 1399: FROM csi_item_instances

1395: SELECT DISTINCT id1, name, description
1396: FROM okx_system_items_v it
1397: WHERE id1 IN
1398: (SELECT inventory_item_id
1399: FROM csi_item_instances
1400: WHERE instance_id IN
1401: (SELECT PR.object_id
1402: FROM csi_ii_relationships PR
1403: WHERE relationship_type_code = 'COMPONENT-OF'

Line 1423: FROM csi_item_instances

1419: (SELECT ciir_pr.subject_id
1420: FROM csi_ii_relationships ciir_pr
1421: WHERE object_id IN
1422: (SELECT instance_id
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

Line 1446: FROM CSI_ITEM_INSTANCES CII,

1442: CII.serial_number,
1443: OOL.unit_selling_price,
1444: '#' id2,
1445: CII.external_reference -- bug 4372877
1446: FROM CSI_ITEM_INSTANCES CII,
1447: CSI_INSTANCE_STATUSES CIS,
1448: OE_ORDER_LINES_ALL OOL,
1449: OKX_SYSTEM_ITEMS_V IT
1450: WHERE CII.INSTANCE_ID = p_instance_id

Line 1463: l_id CSI_ITEM_INSTANCES.instance_id%TYPE;

1459:
1460: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := -99;
1461: l_config_rec l_csr_configuration%ROWTYPE;
1462: l_model_prod_rec l_csr_model_products%ROWTYPE;
1463: l_id CSI_ITEM_INSTANCES.instance_id%TYPE;
1464: l_inv_id NUMBER := -99;
1465: l_id_old NUMBER := -99;
1466: rowcount NUMBER := 1;
1467: i NUMBER := 1;

Line 1541: ' FROM csi_item_instances ' ||

1537: ' START WITH subject_id ' ||
1538: ' IN (SELECT ciir_pr.subject_id ' ||
1539: ' FROM csi_ii_relationships ciir_pr ' ||
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) ))) ' ||

Line 1556: ' FROM csi_item_instances ' ||

1552: ' START WITH subject_id ' ||
1553: ' IN (SELECT ciir_pr.subject_id ' ||
1554: ' FROM csi_ii_relationships ciir_pr ' ||
1555: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
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, ' ||

Line 1577: ' FROM csi_item_instances ' ||

1573: ' START WITH subject_id ' ||
1574: ' IN (SELECT ciir_pr.subject_id ' ||
1575: ' FROM csi_ii_relationships ciir_pr ' ||
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 ' ||

Line 1600: ' FROM csi_item_instances ' ||

1596: ' START WITH subject_id ' ||
1597: ' IN (SELECT ciir_pr.subject_id ' ||
1598: ' FROM csi_ii_relationships ciir_pr ' ||
1599: ' WHERE object_id IN ' || ' ( SELECT instance_id ' ||
1600: ' FROM csi_item_instances ' ||
1601: ' WHERE instance_id = to_char(:l_id))) ' ||
1602: 'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ';
1603:
1604: IF l_start_instance_id IS NOT NULL THEN

Line 1960: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '

1956:
1957: l_order_by_desc := ' order by description ';
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 '

Line 1968: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '

1964: ||' and organization_id = :l_organization_id '
1965: ||' and serviceable_product_flag = ''Y''';
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 '

Line 1982: ||' where inventory_item_id in ( select inventory_item_id from csi_item_instances '

1978: ||' and organization_id = :l_organization_id '
1979: ||' and serviceable_product_flag = ''Y''';
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 '

Line 2177: || ' From CSI_ITEM_INSTANCES CII, '

2173: || ' FROM CSI_SYSTEMS_B CSB, '
2174: || ' CSI_SYSTEMS_TL CST '
2175: || ' WHERE CSB.system_id = CST.system_id '
2176: || ' AND CSB.system_id IN (Select CII.system_id '
2177: || ' From CSI_ITEM_INSTANCES CII, '
2178: || ' CSI_INSTANCE_STATUSES CIS '
2179: || ' , MTL_SYSTEM_ITEMS_B IT '
2180: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2181: || ' AND IT.serviceable_product_flag = ''Y'''

Line 2201: ||' FROM CSI_ITEM_INSTANCES CII, '

2197: || ' CSI_SYSTEMS_TL CST '
2198: || ' WHERE CSB.system_id = CST.system_id '
2199: || ' AND CSB.system_id IN '
2200: ||' (SELECT CII.system_id '
2201: ||' FROM CSI_ITEM_INSTANCES CII, '
2202: ||' CSI_INSTANCE_STATUSES CIS '
2203: ||' , MTL_SYSTEM_ITEMS_B IT '
2204: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2205: || ' AND IT.serviceable_product_flag = ''Y'''

Line 2233: || ' From CSI_ITEM_INSTANCES CII, '

2229: || ' FROM CSI_SYSTEMS_B CSB, '
2230: || ' CSI_SYSTEMS_TL CST '
2231: || ' WHERE CSB.system_id = CST.system_id '
2232: || ' AND CSB.system_id IN (Select CII.system_id '
2233: || ' From CSI_ITEM_INSTANCES CII, '
2234: || ' CSI_INSTANCE_STATUSES CIS '
2235: ||' , MTL_SYSTEM_ITEMS_B IT '
2236: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2237: || ' AND IT.serviceable_product_flag = ''Y'''

Line 2262: || ' From CSI_ITEM_INSTANCES CII, '

2258: || ' FROM CSI_SYSTEMS_B CSB, '
2259: || ' CSI_SYSTEMS_TL CST '
2260: || ' WHERE CSB.system_id = CST.system_id '
2261: || ' AND CSB.system_id IN (Select CII.system_id '
2262: || ' From CSI_ITEM_INSTANCES CII, '
2263: || ' CSI_INSTANCE_STATUSES CIS '
2264: ||' , MTL_SYSTEM_ITEMS_B IT '
2265: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2266: || ' AND IT.serviceable_product_flag = ''Y'''

Line 2429: ||' FROM CSI_ITEM_INSTANCES CII, '

2425: -- Replaced views to base tables where ever possible
2426: l_get_all_sites_sql_c := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2427: || ' FROM OKX_PARTY_SITES_V SI '
2428: || ' WHERE exists (SELECT CII.install_location_Id '
2429: ||' FROM CSI_ITEM_INSTANCES CII, '
2430: ||' CSI_INSTANCE_STATUSES CIS, '
2431: ||' MTL_SYSTEM_ITEMS_B IT '
2432: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2433: ||' AND IT.serviceable_product_flag = ''Y'''

Line 2457: ||' FROM CSI_ITEM_INSTANCES CII, '

2453: -- Replaced views to base tables where ever possible
2454: l_get_all_sites_sql_r := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2455: || ' FROM OKX_PARTY_SITES_V SI '
2456: || ' WHERE exists (SELECT CII.install_location_Id '
2457: ||' FROM CSI_ITEM_INSTANCES CII, '
2458: ||' CSI_INSTANCE_STATUSES CIS '
2459: ||' , MTL_SYSTEM_ITEMS_B IT '
2460: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2461: ||' AND IT.serviceable_product_flag = ''Y'''

Line 2491: || ' FROM CSI_ITEM_INSTANCES CII, '

2487: -- Replaced views to base tables where ever possible
2488: l_get_all_sites_sql_b := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2489: || ' FROM OKX_PARTY_SITES_V SI '
2490: || ' WHERE exists (SELECT CII.install_location_Id '
2491: || ' FROM CSI_ITEM_INSTANCES CII, '
2492: ||' CSI_INSTANCE_STATUSES CIS '
2493: ||' , MTL_SYSTEM_ITEMS_B IT '
2494: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2495: ||' AND IT.serviceable_product_flag = ''Y'''

Line 2527: || ' FROM CSI_ITEM_INSTANCES CII, '

2523:
2524: l_get_all_sites_sql_a := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2525: || ' FROM OKX_PARTY_SITES_V SI '
2526: || ' WHERE exists (SELECT CII.install_location_Id '
2527: || ' FROM CSI_ITEM_INSTANCES CII, '
2528: ||' CSI_INSTANCE_STATUSES CIS '
2529: ||' , MTL_SYSTEM_ITEMS_KFV IT '
2530: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2531: ||' AND IT.serviceable_product_flag = ''Y'''

Line 6623: /* UPDATE csi_item_instances

6619: -- dbms_output.put_line('x_msg_count = '||TO_CHAR(x_msg_count));
6620: -- dbms_output.put_line('x_msg_data = '||x_msg_data);
6621: --- dbms_output.put_line('instance_id = '||p_instance_rec.instance_id);
6622:
6623: /* UPDATE csi_item_instances
6624: SET owner_party_source_table = 'OKC_K_ITEMS_B',
6625: security_group_id = p_cle_id
6626: WHERE instance_id = p_instance_rec.instance_id;
6627: */

Line 7861: FROM CSI_ITEM_INSTANCES CII

7857: get_okc_item_qty_rec get_okc_item_qty_csr%ROWTYPE;
7858:
7859: CURSOR get_csi_item_qty_csr (p_object1_id1 VARCHAR2) IS
7860: SELECT cii.quantity
7861: FROM CSI_ITEM_INSTANCES CII
7862: WHERE instance_id = TO_NUMBER(p_object1_id1);
7863:
7864: get_csi_item_qty_rec get_csi_item_qty_csr%ROWTYPE;
7865: