eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_GTA_ARTRX_PROC dependencies on MTL_SYSTEM_ITEMS_B

Line 2057: l_inventory_item_name mtl_system_items_b.description%TYPE;

2053: --29-JUN-2006 Updated by shujuan
2054: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
2055: l_sales_list_flag VARCHAR2(1);
2056: -- 20-JUL-2006 Shujuan Added length from 60 to 240 for bug 5400805
2057: l_inventory_item_name mtl_system_items_b.description%TYPE;
2058: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;
2059:
2060: -- 29-JUN-2006 Added a parameter to store the unit price of tax currency
2061: -- by Shujuan for bug 5168900

Line 2058: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;

2054: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
2055: l_sales_list_flag VARCHAR2(1);
2056: -- 20-JUL-2006 Shujuan Added length from 60 to 240 for bug 5400805
2057: l_inventory_item_name mtl_system_items_b.description%TYPE;
2058: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;
2059:
2060: -- 29-JUN-2006 Added a parameter to store the unit price of tax currency
2061: -- by Shujuan for bug 5168900
2062: p_tax_curr_unit_price NUMBER;

Line 3737: FROM mtl_system_items_b

3733: BEGIN
3734: SELECT DESCRIPTION, attribute_category
3735: INTO l_inventory_item_name,
3736: l_inventory_attribute_category
3737: FROM mtl_system_items_b
3738: WHERE organization_id = l_master_org --yao zhang modified for bug 7721035
3739: AND inventory_item_id = l_inventory_item_id;
3740:
3741: EXCEPTION

Line 4295: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;

4291: p_attribute_column IN VARCHAR2,
4292: x_attribute_value OUT NOCOPY VARCHAR2) IS
4293: l_procedure_name VARCHAR2(30) := 'get_item_model';
4294:
4295: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;

Line 4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;

4292: x_attribute_value OUT NOCOPY VARCHAR2) IS
4293: l_procedure_name VARCHAR2(30) := 'get_item_model';
4294:
4295: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;

Line 4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;

4293: l_procedure_name VARCHAR2(30) := 'get_item_model';
4294:
4295: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;

Line 4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;

4294:
4295: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;

Line 4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;

4295: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;

Line 4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;

4296: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;

Line 4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;

4297: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;

Line 4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;

4298: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;

Line 4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;

4299: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;

Line 4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;

4300: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;

Line 4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;

4301: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;

Line 4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;

4302: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;

Line 4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;

4303: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;

Line 4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;

4304: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;

Line 4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;

4305: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;

Line 4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;

4306: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;

Line 4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;

4307: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;

Line 4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;

4308: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;

Line 4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;

4309: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;

Line 4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;

4310: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;

Line 4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;

4311: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;

Line 4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;

4312: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;

Line 4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;

4313: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;

Line 4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;

4314: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;

Line 4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;

4315: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;

Line 4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;

4316: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;

Line 4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;

4317: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
4325:

Line 4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;

4318: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
4325:
4326: BEGIN

Line 4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;

4319: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
4325:
4326: BEGIN
4327:

Line 4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;

4320: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
4321: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
4322: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
4323: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
4325:
4326: BEGIN
4327:
4328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4414: FROM mtl_system_items_b

4410: l_inventory_attribute27,
4411: l_inventory_attribute28,
4412: l_inventory_attribute29,
4413: l_inventory_attribute30
4414: FROM mtl_system_items_b
4415: WHERE organization_id = p_item_master_org_id --yao zhang modified for bug 7829039
4416: AND inventory_item_id = p_inventory_item_id;
4417: EXCEPTION
4418: WHEN no_data_found THEN

Line 4913: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

4909: --===========================================================================
4910: PROCEDURE Get_Inventory_Item_Number(p_inventory_item_id IN NUMBER,
4911: p_item_master_org_id IN NUMBER, --yao zhang changed fix bug 7829039
4912: x_inventory_item_code OUT NOCOPY VARCHAR2) IS
4913: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
4914: l_procedure_name VARCHAR2(50) := 'get_inventory_item_number';
4915: BEGIN
4916:
4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4936: FROM MTL_SYSTEM_ITEMS_B_KFV msv

4932: x_inventory_item_code := NULL;
4933: ELSE
4934: SELECT msv.concatenated_segments
4935: INTO l_inventory_item_code
4936: FROM MTL_SYSTEM_ITEMS_B_KFV msv
4937: WHERE msv.inventory_item_id = p_inventory_item_id --yao zhang changed fix bug 7829039
4938: AND msv.organization_id = p_item_master_org_id;
4939:
4940: -- begin log