DBA Data[Home] [Help]

APPS.ASO_ATP_INT dependencies on MTL_ONHAND_ITEMS_V

Line 158: from mtl_onhand_items_v

154: and trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate);
155:
156: cursor c_qty_on_hand(p_inv_item_id number, p_organization_id number) is
157: select total_qoh
158: from mtl_onhand_items_v
159: where organization_id = p_organization_id
160: and inventory_item_id = p_inv_item_id;
161:
162: cursor c_request_date_type(p_quote_header_id number) is