Subinventory uploading for Organizations following Average Costing Methods

Steps to upload Subinventories for organizations following Average Costing Methods:

1. Create a custom table and populate the same using the data provided by the user.
2. Directly insert into the Base table "MTL_SECONDARY_INVENTORIES".

INSERT INTO MTL_SECONDARY_INVENTORIES MT
(MT.SECONDARY_INVENTORY_NAME,
MT.ORGANIZATION_ID,
MT.LAST_UPDATE_DATE,
MT.LAST_UPDATED_BY,
MT.CREATION_DATE,
MT.CREATED_BY,
MT.LAST_UPDATE_LOGIN,
MT.DESCRIPTION,
MT.INVENTORY_ATP_CODE,
MT.AVAILABILITY_TYPE,
MT.RESERVABLE_TYPE,
MT.LOCATOR_TYPE,
MT.MATERIAL_ACCOUNT,
MT.MATERIAL_OVERHEAD_ACCOUNT,
MT.RESOURCE_ACCOUNT,
MT.OVERHEAD_ACCOUNT,
MT.OUTSIDE_PROCESSING_ACCOUNT,
MT.QUANTITY_TRACKED,
MT.ASSET_INVENTORY,
MT.REQUISITION_APPROVAL_TYPE,
MT.EXPENSE_ACCOUNT,
MT.DEPRECIABLE_FLAG,
MT.DEFAULT_COST_GROUP_ID,
MT.STATUS_ID,
MT.LPN_CONTROLLED_FLAG,
MT.CARTONIZATION_FLAG,
MT.SUBINVENTORY_TYPE,
MT.PLANNING_LEVEL,
MT.DEFAULT_COUNT_TYPE_CODE,
MT.ENABLE_BULK_PICK,
MT.ENABLE_LOCATOR_ALIAS,
MT.ENFORCE_ALIAS_UNIQUENESS,
MT.ENABLE_OPP_CYC_COUNT
)
SELECT a.subinv_code,
a.org_id,
SYSDATE,
-1,
SYSDATE,
-1,
50603,
a.suinv_name,
1,
1,
1,
1,
b.material_account,
b.material_overhead_account,
b.resource_account,
b.overhead_account,
b.outside_processing_account,
1,
1,
1,
b.expense_account,
2,
b.default_cost_group_id,
1,
2,
2,
1,
2,
2,
'N',
'N',
'N',
'N'
FROM test_subinv a, mtl_parameters b
WHERE a.org_id = b.organization_id
/******** Excluding the duplicate subinventory codes ************/
AND a.subinv_code NOT IN (SELECT subinv_code
FROM test_subinv
GROUP BY subinv_code, ORGANIZATION
HAVING COUNT (subinv_code) > 1)