APPS.CSP_PARTS_ORDER dependencies on MTL_SECONDARY_INVENTORIES

Line 163: FROM mtl_secondary_inventories

159: RETURN VARCHAR2 IS
160:
161: CURSOR asset_inventory_cur IS
162: SELECT asset_inventory
163: FROM mtl_secondary_inventories
164: WHERE secondary_inventory_name = NVL(p_destination_subinventory,'X')
165: AND organization_id = p_destination_organization_id;
166:
167: l_asset_inventory NUMBER;

Line 254: FROM mtl_secondary_inventories

250: IF (p_destination_subinventory IS NOT NULL) THEN
251: BEGIN
252: SELECT expense_account
253: INTO l_charge_account
254: FROM mtl_secondary_inventories
255: WHERE secondary_inventory_name = p_destination_subinventory
256: AND organization_id = p_destination_organization_id;
257: EXCEPTION
258: WHEN OTHERS THEN

Line 320: FROM mtl_secondary_inventories

316: -- Get Expense Account for the Subinventory
317: BEGIN
318: SELECT expense_account
319: INTO l_charge_account
320: FROM mtl_secondary_inventories
321: WHERE secondary_inventory_name = p_destination_subinventory
322: AND organization_id = p_destination_organization_id;
323: EXCEPTION
324: WHEN OTHERS THEN

Line 347: FROM mtl_secondary_inventories

343: -- Get the Charge_Account for the Subinventory
344: BEGIN
345: SELECT material_account
346: INTO l_charge_account
347: FROM mtl_secondary_inventories
348: WHERE secondary_inventory_name = p_destination_subinventory
349: AND organization_id = p_destination_organization_id;
350: EXCEPTION
351: WHEN OTHERS THEN

Line 1644: MTL_SECONDARY_INVENTORIES sub,

1640: select
1641: nvl(sub.location_id, org.location_id)
1642: into l_header_rec.ship_to_location_id
1643: from
1644: MTL_SECONDARY_INVENTORIES sub,
1645: hr_all_organization_units org
1646: where org.organization_id = l_header_rec.dest_organization_id
1647: and org.organization_id = sub.organization_id(+)
1648: and sub.secondary_inventory_name(+) = l_header_rec.dest_subinventory;