APPS.ASO_TRADEIN_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 26: /* 2633507 - hyang: use mtl_system_items_b instead of vl */

22: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
23: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
24: IS
25:
26: /* 2633507 - hyang: use mtl_system_items_b instead of vl */
27:
28: CURSOR C_Validate_Item(l_inv_item_id NUMBER) IS
29: SELECT returnable_flag, customer_order_enabled_flag, serviceable_product_flag FROM MTL_SYSTEM_ITEMS_B
30: WHERE inventory_item_id = l_inv_item_id

Line 29: SELECT returnable_flag, customer_order_enabled_flag, serviceable_product_flag FROM MTL_SYSTEM_ITEMS_B

25:
26: /* 2633507 - hyang: use mtl_system_items_b instead of vl */
27:
28: CURSOR C_Validate_Item(l_inv_item_id NUMBER) IS
29: SELECT returnable_flag, customer_order_enabled_flag, serviceable_product_flag FROM MTL_SYSTEM_ITEMS_B
30: WHERE inventory_item_id = l_inv_item_id
31: AND organization_id = p_qte_line_rec.organization_id;
32:
33: CURSOR C_inventory_item is

Line 442: FROM CSI_ITEM_INSTANCES a, MTL_SYSTEM_ITEMS_B b

438: */
439: CURSOR C_Get_Item_Details(l_instance_id NUMBER, l_organization_id NUMBER) IS
440: SELECT a.inventory_item_id, a.quantity, a.unit_of_measure,
441: a.last_oe_order_line_id, b.bom_item_type, b.returnable_flag
442: FROM CSI_ITEM_INSTANCES a, MTL_SYSTEM_ITEMS_B b
443: WHERE a.inventory_item_id = b.inventory_item_id
444: AND a.instance_id = l_instance_id
445: AND b.organization_id = l_organization_id;
446: