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 MTL_SYSTEM_ITEMS_KFV

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 1836: TYPE items_rec IS RECORD (inventory_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%TYPE,

1832: l_param_organization_id NUMBER := okc_context.get_okc_organization_id;
1833: l_find NUMBER := p_clvl_filter_rec.clvl_find_id;
1834:
1835:
1836: TYPE items_rec IS RECORD (inventory_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%TYPE,
1837: description VARCHAR2(10000),
1838: name VARCHAR2(10000));
1839:
1840:

Line 1959: l_item_cust := ' from mtl_system_items_kfv '

1955: l_order_by_name := ' order by name ' ;
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)) '

Line 1967: l_item_rel := ' FROM mtl_system_items_kfv '

1963: ||' WHERE party_id = :l_party_id)) '
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 '

Line 1981: l_item_both := ' from mtl_system_items_kfv '

1977: ||' )) '
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 '

Line 1999: l_item_all := ' from mtl_system_items_kfv '

1995: ||' )) '
1996: ||' and organizatioN_id = :l_organization_id '
1997: ||' and serviceable_product_flag = ''Y''';
1998:
1999: l_item_all := ' from mtl_system_items_kfv '
2000: ||' where organizatioN_id = :l_organization_id '
2001: ||' and serviceable_product_flag = ''Y''';
2002:
2003: IF l_clvl_id IS NULL THEN

Line 2529: ||' , MTL_SYSTEM_ITEMS_KFV IT '

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'''
2532: ||' AND IT.organization_id = :l_organization_id '
2533: ||' AND CII.install_location_id = SI.id1 '

Line 4388: l_item_desc MTL_SYSTEM_ITEMS_KFV.description%TYPE;

4384: AND organization_id = p_organization_id
4385: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4386: AND ROWNUM < 2;
4387:
4388: l_item_desc MTL_SYSTEM_ITEMS_KFV.description%TYPE;
4389:
4390: BEGIN
4391:
4392: OPEN l_csr_Get_item_desc(p_inventory_item_id, p_organization_id);

Line 4410: FROM MTL_SYSTEM_ITEMS_KFV

4406: CURSOR l_csr_get_item_name(p_inventory_item_Id IN NUMBER,
4407: p_organization_id IN NUMBER)
4408: IS
4409: SELECT concatenated_segments name
4410: FROM MTL_SYSTEM_ITEMS_KFV
4411: WHERE inventory_item_id = p_inventory_item_id
4412: AND organization_id = p_organization_id
4413: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4414: AND ROWNUM < 2;

Line 4416: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

4412: AND organization_id = p_organization_id
4413: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4414: AND ROWNUM < 2;
4415:
4416: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
4417:
4418: BEGIN
4419:
4420: OPEN l_csr_Get_item_name(p_inventory_item_id, p_organization_id);

Line 6249: FROM mtl_system_items_kfv

6245:
6246: CURSOR l_csr_chk_revision_control(p_item_id IN NUMBER, p_organization_id IN NUMBER)
6247: IS
6248: SELECT revision_qty_control_code
6249: FROM mtl_system_items_kfv
6250: WHERE inventory_item_id = p_item_id
6251: AND organization_id = p_organization_id;
6252:
6253:

Line 6276: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%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;
6278: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
6279: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
6280: