APPS.OE_OE_PRICING_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS

Line 872: FROM MTL_SYSTEM_ITEMS

868: out_price_list_id := null;
869: BEGIN
870: SELECT BOM_ITEM_TYPE,PICK_COMPONENTS_FLAG
871: INTO l_bom_item_type,l_pick_components_flag
872: FROM MTL_SYSTEM_ITEMS
873: WHERE INVENTORY_ITEM_ID= in_item_id
874: AND ORGANIZATION_ID=in_org_id;
875: IF l_bom_item_type=4 AND l_pick_components_flag='N' THEN
876: out_item_type_code := 'STANDARD';

Line 1186: FROM MTL_SYSTEM_ITEMS

1182:
1183: BEGIN
1184: SELECT BOM_ITEM_TYPE,PICK_COMPONENTS_FLAG
1185: INTO l_bom_item_type,l_pick_components_flag
1186: FROM MTL_SYSTEM_ITEMS
1187: WHERE INVENTORY_ITEM_ID= in_out_default_rec.inventory_item_id
1188: AND ORGANIZATION_ID=in_out_default_rec.org_id;
1189: IF l_bom_item_type=4 AND l_pick_components_flag='N' THEN
1190: in_out_default_rec.item_type_code := 'STANDARD';

Line 1624: FROM mtl_system_items msi

1620: END IF;
1621:
1622: SELECT msi.lot_control_code
1623: INTO l_lot_control_code
1624: FROM mtl_system_items msi
1625: WHERE msi.inventory_item_id = p_item_id
1626: AND msi.organization_id = nvl(p_org_id,l_org_id);
1627:
1628: IF l_lot_control_code = 2 THEN

Line 2326: FROM mtl_system_items_kfv

2322: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2323:
2324: SELECT concatenated_segments
2325: INTO oe_order_pub.g_line.ordered_item
2326: FROM mtl_system_items_kfv
2327: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
2328: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2329:
2330: End IF;

Line 5445: FROM mtl_system_items_kfv

5441: oe_debug_pub.add('GSA warning or error');
5442: Begin
5443: SELECT concatenated_segments
5444: INTO l_msg_text
5445: FROM mtl_system_items_kfv
5446: WHERE inventory_item_id = g_inventory_item_id
5447: AND organization_id = l_org_id;
5448: Exception
5449: when no_data_found then

Line 5552: FROM mtl_system_items_kfv

5548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5549: BEGIN
5550: SELECT concatenated_segments
5551: INTO out_inv_item_name
5552: FROM mtl_system_items_kfv
5553: WHERE inventory_item_id = l_inv_item_id
5554: AND organization_id = l_org_id;
5555:
5556:

Line 5607: FROM mtl_system_items_kfv

5603: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5604: BEGIN
5605: SELECT concatenated_segments,description,item_type
5606: INTO out_inv_item_name,out_inv_desc,out_inv_item_type
5607: FROM mtl_system_items_kfv
5608: WHERE inventory_item_id = l_inv_item_id
5609: AND organization_id = l_org_id;
5610:
5611:

Line 6126: FROM mtl_system_items

6122: bom_item_type,
6123: replenish_to_order_flag,
6124: build_in_wip_flag,
6125: decode(default_so_source_type,'EXTERNAL','External','INTERNAL','Internal')
6126: FROM mtl_system_items
6127: WHERE inventory_item_id = in_inventory_item_id
6128: AND organization_id = in_org_id;
6129:
6130: l_default_shipping_org number;

Line 6750: FROM mtl_system_items_b

6746: )IS
6747:
6748: CURSOR c_items IS
6749: SELECT primary_uom_code
6750: FROM mtl_system_items_b
6751: WHERE organization_id = in_org_id
6752: AND inventory_item_id = g_panda_rec_table(1).p_Inventory_item_id;
6753:
6754: CURSOR c_class(in_ordered_uom in varchar2) is

Line 8359: FROM mtl_system_items

8355:
8356: CURSOR c_atp_flag IS
8357: SELECT atp_flag,
8358: decode(default_so_source_type,'EXTERNAL','External','INTERNAL','Internal')
8359: FROM mtl_system_items
8360: WHERE inventory_item_id = in_inventory_item_id
8361: AND organization_id = in_org_id;
8362:
8363: BEGIN