APPS.OE_OE_PRICING_AVAILABILITY dependencies on MTL_SYSTEM_ITEMS

Line 868: FROM MTL_SYSTEM_ITEMS

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

Line 1182: FROM MTL_SYSTEM_ITEMS

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

Line 1614: FROM mtl_system_items msi

1610: END IF;
1611:
1612: SELECT msi.lot_control_code
1613: INTO l_lot_control_code
1614: FROM mtl_system_items msi
1615: WHERE msi.inventory_item_id = p_item_id
1616: AND msi.organization_id = nvl(p_org_id,l_org_id);
1617:
1618: IF l_lot_control_code = 2 THEN

Line 2301: FROM mtl_system_items_kfv

2297: IF g_panda_rec_table(p_line_index).p_item_identifier_type ='INT' then
2298:
2299: SELECT concatenated_segments
2300: INTO oe_order_pub.g_line.ordered_item
2301: FROM mtl_system_items_kfv
2302: WHERE inventory_item_id = g_panda_rec_table(p_line_index).p_inventory_item_id
2303: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2304:
2305: End IF;

Line 5420: FROM mtl_system_items_kfv

5416: oe_debug_pub.add('GSA warning or error');
5417: Begin
5418: SELECT concatenated_segments
5419: INTO l_msg_text
5420: FROM mtl_system_items_kfv
5421: WHERE inventory_item_id = g_inventory_item_id
5422: AND organization_id = l_org_id;
5423: Exception
5424: when no_data_found then

Line 5527: FROM mtl_system_items_kfv

5523: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5524: BEGIN
5525: SELECT concatenated_segments
5526: INTO out_inv_item_name
5527: FROM mtl_system_items_kfv
5528: WHERE inventory_item_id = l_inv_item_id
5529: AND organization_id = l_org_id;
5530:
5531:

Line 5582: FROM mtl_system_items_kfv

5578: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5579: BEGIN
5580: SELECT concatenated_segments,description,item_type
5581: INTO out_inv_item_name,out_inv_desc,out_inv_item_type
5582: FROM mtl_system_items_kfv
5583: WHERE inventory_item_id = l_inv_item_id
5584: AND organization_id = l_org_id;
5585:
5586:

Line 6101: FROM mtl_system_items

6097: bom_item_type,
6098: replenish_to_order_flag,
6099: build_in_wip_flag,
6100: decode(default_so_source_type,'EXTERNAL','External','INTERNAL','Internal')
6101: FROM mtl_system_items
6102: WHERE inventory_item_id = in_inventory_item_id
6103: AND organization_id = in_org_id;
6104:
6105: l_default_shipping_org number;

Line 6725: FROM mtl_system_items_b

6721: )IS
6722:
6723: CURSOR c_items IS
6724: SELECT primary_uom_code
6725: FROM mtl_system_items_b
6726: WHERE organization_id = in_org_id
6727: AND inventory_item_id = g_panda_rec_table(1).p_Inventory_item_id;
6728:
6729: CURSOR c_class(in_ordered_uom in varchar2) is

Line 8334: FROM mtl_system_items

8330:
8331: CURSOR c_atp_flag IS
8332: SELECT atp_flag,
8333: decode(default_so_source_type,'EXTERNAL','External','INTERNAL','Internal')
8334: FROM mtl_system_items
8335: WHERE inventory_item_id = in_inventory_item_id
8336: AND organization_id = in_org_id;
8337:
8338: BEGIN