Monday, August 31, 2009

Inventory item Locator creation in oracle inventory R12

The following API Creates Inventory Locator For an item.
Please put the appropriate values for item required.

APPS.INV_LOC_WMS_PUB.CREATE_LOCATOR (
x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_inventory_location_id => v_inventory_location_id
,x_locator_exists => v_locator_exists
,p_organization_id => v_organization_id
,p_organization_code => NULL
,p_concatenated_segments => rec.locator_segment1||'.'||rec.locator_segment2||'.'||rec.locator_segment3
,p_description => 'desc'
,p_inventory_location_type => 1
,p_picking_order => NULL
,p_location_maximum_units => NULL
,p_SUBINVENTORY_CODE => V_SEC_INV_NAME -- 'Stag'
,p_LOCATION_WEIGHT_UOM_CODE => NULL
,p_mAX_WEIGHT => NULL
,p_vOLUME_UOM_CODE => NULL
,p_mAX_CUBIC_AREA => NULL
,p_x_COORDINATE => NULL
,p_Y_COORDINATE => NULL
,p_Z_COORDINATE => NULL
,p_PHYSICAL_LOCATION_ID => NULL
,p_PICK_UOM_CODE => NULL
,p_DIMENSION_UOM_CODE => NULL
,p_LENGTH => NULL
,p_WIDTH => NULL
,p_HEIGHT => NULL
,p_STATUS_ID => V_STATUS_ID -- 1
,p_dropping_order => NULL
,p_attribute_category => NULL
,p_attribute1 => NULL
,p_attribute2 => NULL
,p_attribute3 => NULL
,p_attribute4 => NULL
,p_attribute5 => NULL
,p_attribute6 => NULL
,p_attribute7 => NULL
,p_attribute8 => NULL
,p_attribute9 => NULL
,p_attribute10 => NULL
,p_attribute11 => NULL
,p_attribute12 => NULL
,p_attribute13 => NULL
,p_attribute14 => NULL
,p_attribute15 => NULL
,p_alias => NULL
) ;


cheers!!

No comments:

Post a Comment