APPS.ECE_INVENTORY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

	SELECT  MIN(ITEM_NUMBER) INTO cItem_num
	FROM 	MTL_ITEM_FLEXFIELDS MSIV
	WHERE   MSIV.ITEM_ID = i_item_id
	AND	MSIV.ORGANIZATION_ID = i_org_id;

Line: 40

	SELECT	MSIV.ATTRIBUTE_CATEGORY,
		MSIV.ATTRIBUTE1,
		MSIV.ATTRIBUTE2,
		MSIV.ATTRIBUTE3,
		MSIV.ATTRIBUTE4,
		MSIV.ATTRIBUTE5,
		MSIV.ATTRIBUTE6,
		MSIV.ATTRIBUTE7,
		MSIV.ATTRIBUTE8,
		MSIV.ATTRIBUTE9,
		MSIV.ATTRIBUTE10,
		MSIV.ATTRIBUTE11,
		MSIV.ATTRIBUTE12,
		MSIV.ATTRIBUTE13,
		MSIV.ATTRIBUTE14,
		MSIV.ATTRIBUTE15
	INTO	o_attribute_category,
		o_attribute_1,
		o_attribute_2,
		o_attribute_3,
		o_attribute_4,
		o_attribute_5,
		o_attribute_6,
		o_attribute_7,
		o_attribute_8,
		o_attribute_9,
		o_attribute_10,
		o_attribute_11,
		o_attribute_12,
		o_attribute_13,
		o_attribute_14,
		o_attribute_15
	FROM 	MTL_ITEM_FLEXFIELDS MSIV
	WHERE   MSIV.ITEM_ID = i_item_id
	AND	MSIV.ORGANIZATION_ID = i_org_id
	AND	MSIV.ITEM_NUMBER = cItem_num
	AND	ROWNUM = 1;

Line: 103

SELECT  SUBSTRB(MIN(CONCATENATED_SEGMENTS),1,100) INTO o_location
FROM 	MTL_ITEM_LOCATIONS_KFV MILK
WHERE   MILK.INVENTORY_LOCATION_ID = i_inventory_location_id
AND	MILK.ORGANIZATION_ID = i_organization_id;