[Home] [Help]
35: -- mtp.organization_code,
36: COUNT(category_id)
37: FROM
38: mtl_system_items_kfv mti,
39: -- mtl_parameters mtp,
40: mtl_item_categories cat
41: WHERE
42: mti.inventory_item_id = cat.inventory_item_id AND
43: mti.organization_id = cat.organization_id AND
429: mti.weight_uom_code,
430: mti.volume_uom_code,
431: mti.eam_item_type
432: FROM mtl_system_items_b_kfv mti,
433: mtl_parameters mtp,
434: mtl_item_categories mic ,
435: mtl_item_categories mic1 ,
436: mtl_item_categories mic2 ,
437: mtl_categories_b_kfv kfv ,
605: mti.creation_date,
606: mti.last_update_date
607: FROM
608: mtl_system_items_b_kfv mti,
609: mtl_parameters mtp,
610: mtl_item_categories mic,
611: mtl_item_categories mic1,
612: mtl_item_categories mic2,
613: mtl_categories_b_kfv kfv,
850: 'Unassigned',
851: mti.creation_date,
852: mti.last_update_date
853: FROM mtl_system_items_b_kfv mti,
854: mtl_parameters mtp
855: WHERE mti.inventory_item_id = p_inventory_item_id
856: AND mti.organization_id = p_organization_id
857: AND mti.organization_id= mtp.organization_id;
858:
909:
910: BEGIN
911: SELECT msik.concatenated_segments || ' (' || mp.organization_code || ')' Value INTO l_pres_item_number
912: FROM mtl_system_items_b_kfv msik,
913: mtl_parameters mp
914: WHERE msik.inventory_item_id=p_inventory_item_id
915: AND msik.organization_id=mp.organization_id
916: AND mp.organization_id=p_organization_id;
917: EXCEPTION
968: ,mti.unit_volume
969: ,mti.weight_uom_code
970: ,mti.volume_uom_code
971: FROM mtl_system_items_b_kfv mti
972: , mtl_parameters b
973: WHERE mti.inventory_item_id = p_inventory_item_id
974: AND mti.organization_id = b.organization_id
975: AND b.master_organization_id <> p_organization_id;
976:
1077: ,mti.weight_uom_code
1078: ,mti.volume_uom_code
1079: ,mti.eam_item_type
1080: FROM mtl_system_items_b_kfv mti
1081: , mtl_parameters b
1082: WHERE mti.inventory_item_id = p_inventory_item_id
1083: AND mti.organization_id = b.organization_id
1084: AND b.master_organization_id = p_organization_id;
1085: -- updates to child-org-level attributes are confined to that organization
1129: END IF;
1130: /* end fix for bug 16179463 */
1131:
1132: SELECT COUNT(master_organization_id) INTO isMasterOrg
1133: FROM mtl_parameters
1134: WHERE master_organization_id = p_organization_id AND ROWNUM < 2;
1135:
1136: IF isMasterOrg = 1 THEN
1137: FOR c_items_in_master_rec IN c_items_in_master
1422: WHERE
1423: msi.inventory_item_id = p_inventory_item_id
1424: AND (msi.organization_id = p_organization_id
1425: or msi.organization_id in (SELECT mp.organization_id
1426: FROM mtl_parameters mp
1427: WHERE
1428: mp.master_organization_id = p_organization_id))
1429: AND mic.inventory_item_id (+) = msi.inventory_item_id
1430: AND mic.organization_id (+) = msi.organization_id
1683: , item.creation_date
1684: , item.last_update_date
1685: FROM mtl_system_items_interface interface
1686: , mtl_system_items_b_kfv item
1687: , mtl_parameters mtp
1688: , mtl_item_categories mic
1689: , mtl_categories_b_kfv kfv
1690: , mtl_item_categories mic1
1691: , mtl_categories_b_kfv kfv1
1813: , item.creation_date
1814: , item.last_update_date
1815: FROM mtl_system_items_interface interface
1816: , mtl_system_items_b_kfv item
1817: , mtl_parameters mtp
1818: , mtl_item_categories mic
1819: , mtl_categories_b_kfv kfv
1820: , mtl_item_categories mic1
1821: , mtl_categories_b_kfv kfv1
2047: CURSOR icoi_csr (p_set_process_id NUMBER) IS
2048: SELECT mici.inventory_item_id
2049: ,mp.organization_id
2050: FROM mtl_item_categories_interface mici
2051: ,mtl_parameters mp
2052: WHERE mici.set_process_id = p_set_process_id
2053: AND mici.request_id = l_conc_request_id
2054: AND mici.process_flag = l_process_flag
2055: AND ( mici.category_set_id = l_INV_category_set_id