APPS.CSP_STOCK_LISTS_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 106: FROM MTL_ITEM_SUB_INVENTORIES

102: ,x_return_status out NOCOPY VARCHAR2) AS
103:
104: CURSOR get_subinv_items IS
105: SELECT *
106: FROM MTL_ITEM_SUB_INVENTORIES
107: where INVENTORY_ITEM_ID = p_inventory_item_id
108: and ORGANIZATION_ID = p_organization_id
109: and SECONDARY_INVENTORY = p_secondary_inventory;
110:

Line 111: l_rec MTL_ITEM_SUB_INVENTORIES%ROWTYPE;

107: where INVENTORY_ITEM_ID = p_inventory_item_id
108: and ORGANIZATION_ID = p_organization_id
109: and SECONDARY_INVENTORY = p_secondary_inventory;
110:
111: l_rec MTL_ITEM_SUB_INVENTORIES%ROWTYPE;
112: l_item_id NUMBER;
113: BEGIN
114: l_item_id := p_inventory_item_id;
115: OPEN get_subinv_items;