APPS.OE_BULK_CACHE dependencies on MTL_SYSTEM_ITEMS

Line 581: FROM mtl_system_items

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

Line 701: FROM MTL_SYSTEM_ITEMS msi,

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

Line 702: MTL_SYSTEM_ITEMS_KFV kfv

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

Line 799: FROM MTL_SYSTEM_ITEMS

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