DBA Data[Home] [Help]

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

1304:
1305: l_param_organization_id NUMBER := okc_context.get_okc_organization_id;
1306: l_find NUMBER := p_clvl_filter_rec.clvl_find_id;
1307:
1308: TYPE items_rec IS RECORD (inventory_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%TYPE,
1309: description VARCHAR2(10000),
1310: name VARCHAR2(10000));
1311:
1312:

Line 1431: l_item_cust := ' from mtl_system_items_kfv '

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

Line 1439: l_item_rel := ' FROM mtl_system_items_kfv '

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

Line 1453: l_item_both := ' from mtl_system_items_kfv '

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

Line 1471: l_item_all := ' from mtl_system_items_kfv '

1467: ||' )) '
1468: ||' and organizatioN_id = :l_organization_id '
1469: ||' and serviceable_product_flag = ''Y''';
1470:
1471: l_item_all := ' from mtl_system_items_kfv '
1472: ||' where organizatioN_id = :l_organization_id '
1473: ||' and serviceable_product_flag = ''Y''';
1474:
1475: IF l_clvl_id IS NULL THEN

Line 2001: ||' , MTL_SYSTEM_ITEMS_KFV IT '

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

Line 3848: l_item_desc MTL_SYSTEM_ITEMS_KFV.description%TYPE;

3844: AND organization_id = p_organization_id
3845: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3846: AND ROWNUM < 2;
3847:
3848: l_item_desc MTL_SYSTEM_ITEMS_KFV.description%TYPE;
3849:
3850: BEGIN
3851:
3852: OPEN l_csr_Get_item_desc(p_inventory_item_id, p_organization_id);

Line 3870: FROM MTL_SYSTEM_ITEMS_KFV

3866: CURSOR l_csr_get_item_name(p_inventory_item_Id IN NUMBER,
3867: p_organization_id IN NUMBER)
3868: IS
3869: SELECT concatenated_segments name
3870: FROM MTL_SYSTEM_ITEMS_KFV
3871: WHERE inventory_item_id = p_inventory_item_id
3872: AND organization_id = p_organization_id
3873: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3874: AND ROWNUM < 2;

Line 3876: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

3872: AND organization_id = p_organization_id
3873: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3874: AND ROWNUM < 2;
3875:
3876: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
3877:
3878: BEGIN
3879:
3880: OPEN l_csr_Get_item_name(p_inventory_item_id, p_organization_id);

Line 5635: FROM mtl_system_items_kfv

5631:
5632: CURSOR l_csr_chk_revision_control(p_item_id IN NUMBER, p_organization_id IN NUMBER)
5633: IS
5634: SELECT revision_qty_control_code
5635: FROM mtl_system_items_kfv
5636: WHERE inventory_item_id = p_item_id
5637: AND organization_id = p_organization_id;
5638:
5639:

Line 5662: l_revision_control_yn MTL_SYSTEM_ITEMS_KFV.revision_qty_control_code%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;
5664: l_ship_to_site_use_id OKC_K_HEADERS_B.ship_to_site_use_id%TYPE;
5665: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
5666: