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 815: csi_item_instances

811: description
812: FROM okx_system_items_v it
813: WHERE id1 IN
814: (SELECT inventory_item_id FROM
815: csi_item_instances
816: WHERE instance_id IN (SELECT PR.object_id
817: FROM csi_ii_relationships PR
818: WHERE relationship_type_code = 'COMPONENT-OF'
819: AND NOT EXISTS (SELECT cp.subject_id FROM csi_ii_relationships cp

Line 841: FROM csi_item_instances

837: IN (SELECT ciir_pr.subject_id
838: FROM csi_ii_relationships ciir_pr
839: WHERE object_id IN
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)))

Line 867: FROM CSI_ITEM_INSTANCES CII

863: , CII.serial_number
864: , OOL.unit_selling_price
865: , '#' id2
866: , CII.external_reference -- bug 4372877
867: FROM CSI_ITEM_INSTANCES CII
868: , CSI_INSTANCE_STATUSES CIS
869: , OE_ORDER_LINES_ALL OOL
870: , OKX_SYSTEM_ITEMS_V IT
871: WHERE CII.INSTANCE_ID = p_instance_id

Line 883: l_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE;

879:
880: l_config_parent_id CSI_II_RELATIONSHIPS.object_id%TYPE := - 99;
881: l_config_rec l_csr_configuration%ROWTYPE;
882: l_model_prod_rec l_csr_model_products%ROWTYPE;
883: l_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE;
884: l_inv_id NUMBER := - 99;
885: l_id_old NUMBER := - 99;
886: rowcount NUMBER := 1;
887: i NUMBER := 1;

Line 917: ||' FROM csi_item_instances '

913: ||' IN (SELECT ciir_pr.subject_id '
914: ||' FROM csi_ii_relationships ciir_pr '
915: ||' WHERE object_id IN '
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) ))) '

Line 935: ||' FROM csi_item_instances '

931: ||' IN (SELECT ciir_pr.subject_id '
932: ||' FROM csi_ii_relationships ciir_pr '
933: ||' WHERE object_id IN '
934: ||' ( SELECT instance_id '
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, '

Line 959: ||' FROM csi_item_instances '

955: ||' IN (SELECT ciir_pr.subject_id '
956: ||' FROM csi_ii_relationships ciir_pr '
957: ||' WHERE object_id IN '
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)) '

Line 986: ||' FROM csi_item_instances '

982: ||' IN (SELECT ciir_pr.subject_id '
983: ||' FROM csi_ii_relationships ciir_pr '
984: ||' WHERE object_id IN '
985: ||' ( SELECT instance_id '
986: ||' FROM csi_item_instances '
987: ||' WHERE inventory_item_id = to_char(:l_id))) '
988: ||'CONNECT BY ciir.object_id = PRIOR ciir.subject_id ' ;
989:
990:

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

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

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

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

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

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

Line 1649: || ' From CSI_ITEM_INSTANCES CII, '

1645: || ' FROM CSI_SYSTEMS_B CSB, '
1646: || ' CSI_SYSTEMS_TL CST '
1647: || ' WHERE CSB.system_id = CST.system_id '
1648: || ' AND CSB.system_id IN (Select CII.system_id '
1649: || ' From CSI_ITEM_INSTANCES CII, '
1650: || ' CSI_INSTANCE_STATUSES CIS '
1651: || ' , MTL_SYSTEM_ITEMS_B IT '
1652: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1653: || ' AND IT.serviceable_product_flag = ''Y'''

Line 1673: ||' FROM CSI_ITEM_INSTANCES CII, '

1669: || ' CSI_SYSTEMS_TL CST '
1670: || ' WHERE CSB.system_id = CST.system_id '
1671: || ' AND CSB.system_id IN '
1672: ||' (SELECT CII.system_id '
1673: ||' FROM CSI_ITEM_INSTANCES CII, '
1674: ||' CSI_INSTANCE_STATUSES CIS '
1675: ||' , MTL_SYSTEM_ITEMS_B IT '
1676: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1677: || ' AND IT.serviceable_product_flag = ''Y'''

Line 1705: || ' From CSI_ITEM_INSTANCES CII, '

1701: || ' FROM CSI_SYSTEMS_B CSB, '
1702: || ' CSI_SYSTEMS_TL CST '
1703: || ' WHERE CSB.system_id = CST.system_id '
1704: || ' AND CSB.system_id IN (Select CII.system_id '
1705: || ' From CSI_ITEM_INSTANCES CII, '
1706: || ' CSI_INSTANCE_STATUSES CIS '
1707: ||' , MTL_SYSTEM_ITEMS_B IT '
1708: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1709: || ' AND IT.serviceable_product_flag = ''Y'''

Line 1734: || ' From CSI_ITEM_INSTANCES CII, '

1730: || ' FROM CSI_SYSTEMS_B CSB, '
1731: || ' CSI_SYSTEMS_TL CST '
1732: || ' WHERE CSB.system_id = CST.system_id '
1733: || ' AND CSB.system_id IN (Select CII.system_id '
1734: || ' From CSI_ITEM_INSTANCES CII, '
1735: || ' CSI_INSTANCE_STATUSES CIS '
1736: ||' , MTL_SYSTEM_ITEMS_B IT '
1737: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1738: || ' AND IT.serviceable_product_flag = ''Y'''

Line 1901: ||' FROM CSI_ITEM_INSTANCES CII, '

1897: -- Replaced views to base tables where ever possible
1898: l_get_all_sites_sql_c := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1899: || ' FROM OKX_PARTY_SITES_V SI '
1900: || ' WHERE exists (SELECT CII.install_location_Id '
1901: ||' FROM CSI_ITEM_INSTANCES CII, '
1902: ||' CSI_INSTANCE_STATUSES CIS, '
1903: ||' MTL_SYSTEM_ITEMS_B IT '
1904: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
1905: ||' AND IT.serviceable_product_flag = ''Y'''

Line 1929: ||' FROM CSI_ITEM_INSTANCES CII, '

1925: -- Replaced views to base tables where ever possible
1926: l_get_all_sites_sql_r := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1927: || ' FROM OKX_PARTY_SITES_V SI '
1928: || ' WHERE exists (SELECT CII.install_location_Id '
1929: ||' FROM CSI_ITEM_INSTANCES CII, '
1930: ||' CSI_INSTANCE_STATUSES CIS '
1931: ||' , MTL_SYSTEM_ITEMS_B IT '
1932: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
1933: ||' AND IT.serviceable_product_flag = ''Y'''

Line 1963: || ' FROM CSI_ITEM_INSTANCES CII, '

1959: -- Replaced views to base tables where ever possible
1960: l_get_all_sites_sql_b := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1961: || ' FROM OKX_PARTY_SITES_V SI '
1962: || ' WHERE exists (SELECT CII.install_location_Id '
1963: || ' FROM CSI_ITEM_INSTANCES CII, '
1964: ||' CSI_INSTANCE_STATUSES CIS '
1965: ||' , MTL_SYSTEM_ITEMS_B IT '
1966: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
1967: ||' AND IT.serviceable_product_flag = ''Y'''

Line 1999: || ' FROM CSI_ITEM_INSTANCES CII, '

1995:
1996: l_get_all_sites_sql_a := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1997: || ' FROM OKX_PARTY_SITES_V SI '
1998: || ' WHERE exists (SELECT CII.install_location_Id '
1999: || ' FROM CSI_ITEM_INSTANCES CII, '
2000: ||' CSI_INSTANCE_STATUSES CIS '
2001: ||' , MTL_SYSTEM_ITEMS_KFV IT '
2002: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2003: ||' AND IT.serviceable_product_flag = ''Y'''

Line 6003: /* UPDATE csi_item_instances

5999: -- dbms_output.put_line('x_msg_count = '||TO_CHAR(x_msg_count));
6000: -- dbms_output.put_line('x_msg_data = '||x_msg_data);
6001: --- dbms_output.put_line('instance_id = '||p_instance_rec.instance_id);
6002:
6003: /* UPDATE csi_item_instances
6004: SET owner_party_source_table = 'OKC_K_ITEMS_B',
6005: security_group_id = p_cle_id
6006: WHERE instance_id = p_instance_rec.instance_id;
6007: */

Line 7197: FROM CSI_ITEM_INSTANCES CII

7193: get_okc_item_qty_rec get_okc_item_qty_csr%ROWTYPE;
7194:
7195: CURSOR get_csi_item_qty_csr (p_object1_id1 VARCHAR2) IS
7196: SELECT cii.quantity
7197: FROM CSI_ITEM_INSTANCES CII
7198: WHERE instance_id = TO_NUMBER(p_object1_id1);
7199:
7200: get_csi_item_qty_rec get_csi_item_qty_csr%ROWTYPE;
7201: