APPS.OE_BULK_CACHE dependencies on MTL_SYSTEM_ITEMS

Line 580: FROM mtl_system_items

576: , grade_ctl -- OPM HVOP
577: FROM ic_item_mst
578: WHERE delete_mark = 0
579: AND item_no in (SELECT segment1
580: FROM mtl_system_items
581: WHERE organization_id = discrete_org_id
582: AND inventory_item_id = discrete_item_id);
583: --OPM 02/JUN/00 END
584: --=================

Line 700: FROM MTL_SYSTEM_ITEMS msi,

696: ,G_ITEM_TBL(p_key1).ordered_item
697: ,G_ITEM_TBL(p_key1).full_lead_time
698: ,G_ITEM_TBL(p_key1).fixed_lead_time
699: ,G_ITEM_TBL(p_key1).variable_lead_time
700: FROM MTL_SYSTEM_ITEMS msi,
701: MTL_SYSTEM_ITEMS_KFV kfv
702: WHERE msi.INVENTORY_ITEM_ID = p_key1
703: AND msi.ORGANIZATION_ID = l_key2
704: AND kfv.INVENTORY_ITEM_ID = p_key1

Line 701: MTL_SYSTEM_ITEMS_KFV kfv

697: ,G_ITEM_TBL(p_key1).full_lead_time
698: ,G_ITEM_TBL(p_key1).fixed_lead_time
699: ,G_ITEM_TBL(p_key1).variable_lead_time
700: FROM MTL_SYSTEM_ITEMS msi,
701: MTL_SYSTEM_ITEMS_KFV kfv
702: WHERE msi.INVENTORY_ITEM_ID = p_key1
703: AND msi.ORGANIZATION_ID = l_key2
704: AND kfv.INVENTORY_ITEM_ID = p_key1
705: AND kfv.ORGANIZATION_ID = l_key2;

Line 798: FROM MTL_SYSTEM_ITEMS

794: ,G_ITEM_TBL(p_key1).secondary_default_ind
795: ,G_ITEM_TBL(p_key1).lot_divisible_flag
796: ,G_ITEM_TBL(p_key1).grade_control_flag
797: ,G_ITEM_TBL(p_key1).lot_control_code
798: FROM MTL_SYSTEM_ITEMS
799: WHERE INVENTORY_ITEM_ID = p_key1
800: AND ORGANIZATION_ID = p_key2; -- ship from org
801:
802: IF l_debug_level > 0 THEN