APPS.ASO_TRADEIN_PVT dependencies on CSI_ITEM_INSTANCES

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:

Line 950: FROM CSI_ITEM_INSTANCES

946: WHERE line_id = l_line_id;
947:
948: CURSOR C_Get_Inst_Qty(l_inst_id NUMBER) IS
949: SELECT quantity
950: FROM CSI_ITEM_INSTANCES
951: WHERE instance_id = l_inst_id;
952:
953: CURSOR C_Get_Inst_Ret_Info(l_inst_id NUMBER) IS
954: SELECT last_oe_order_line_id

Line 955: FROM CSI_ITEM_INSTANCES

951: WHERE instance_id = l_inst_id;
952:
953: CURSOR C_Get_Inst_Ret_Info(l_inst_id NUMBER) IS
954: SELECT last_oe_order_line_id
955: FROM CSI_ITEM_INSTANCES
956: WHERE instance_id = l_inst_id;
957:
958: l_qty NUMBER;
959: l_qte_quantity NUMBER;