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.JMF_GTA_ARTRX_PROC dependencies on MTL_SYSTEM_ITEMS_B

Line 2001: l_inventory_item_name mtl_system_items_b.description%TYPE;

1997: --29-JUN-2006 Updated by shujuan
1998: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
1999: l_sales_list_flag VARCHAR2(1);
2000: -- 20-JUL-2006 Shujuan Added length from 60 to 240 for bug 5400805
2001: l_inventory_item_name mtl_system_items_b.description%TYPE;
2002: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;
2003:
2004: -- 29-JUN-2006 Added a parameter to store the unit price of tax currency
2005: -- by Shujuan for bug 5168900

Line 2002: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;

1998: l_cross_reference MTL_CROSS_REFERENCES_B.cross_reference%TYPE;
1999: l_sales_list_flag VARCHAR2(1);
2000: -- 20-JUL-2006 Shujuan Added length from 60 to 240 for bug 5400805
2001: l_inventory_item_name mtl_system_items_b.description%TYPE;
2002: l_inventory_attribute_category mtl_system_items_b.attribute_category%TYPE;
2003:
2004: -- 29-JUN-2006 Added a parameter to store the unit price of tax currency
2005: -- by Shujuan for bug 5168900
2006: p_tax_curr_unit_price NUMBER;

Line 3383: FROM mtl_system_items_b

3379: BEGIN
3380: SELECT DESCRIPTION, attribute_category
3381: INTO l_inventory_item_name,
3382: l_inventory_attribute_category
3383: FROM mtl_system_items_b
3384: WHERE organization_id = l_master_org--yao zhang modified for bug 7721035
3385: AND inventory_item_id = l_inventory_item_id;
3386:
3387: EXCEPTION

Line 3907: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;

3903: p_attribute_column IN VARCHAR2,
3904: x_attribute_value OUT NOCOPY VARCHAR2) IS
3905: l_procedure_name VARCHAR2(30) := 'get_item_model';
3906:
3907: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;

Line 3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;

3904: x_attribute_value OUT NOCOPY VARCHAR2) IS
3905: l_procedure_name VARCHAR2(30) := 'get_item_model';
3906:
3907: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;

Line 3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;

3905: l_procedure_name VARCHAR2(30) := 'get_item_model';
3906:
3907: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;

Line 3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;

3906:
3907: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;

Line 3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;

3907: l_inventory_attribute1 mtl_system_items_b.attribute1%TYPE;
3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;

Line 3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;

3908: l_inventory_attribute2 mtl_system_items_b.attribute2%TYPE;
3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;

Line 3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;

3909: l_inventory_attribute3 mtl_system_items_b.attribute3%TYPE;
3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;

Line 3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;

3910: l_inventory_attribute4 mtl_system_items_b.attribute4%TYPE;
3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;

Line 3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;

3911: l_inventory_attribute5 mtl_system_items_b.attribute5%TYPE;
3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;

Line 3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;

3912: l_inventory_attribute6 mtl_system_items_b.attribute6%TYPE;
3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;

Line 3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;

3913: l_inventory_attribute7 mtl_system_items_b.attribute7%TYPE;
3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;

Line 3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;

3914: l_inventory_attribute8 mtl_system_items_b.attribute8%TYPE;
3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;

Line 3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;

3915: l_inventory_attribute9 mtl_system_items_b.attribute9%TYPE;
3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;

Line 3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;

3916: l_inventory_attribute10 mtl_system_items_b.attribute10%TYPE;
3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;

Line 3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;

3917: l_inventory_attribute11 mtl_system_items_b.attribute11%TYPE;
3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;

Line 3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;

3918: l_inventory_attribute12 mtl_system_items_b.attribute12%TYPE;
3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;

Line 3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;

3919: l_inventory_attribute13 mtl_system_items_b.attribute13%TYPE;
3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;

Line 3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;

3920: l_inventory_attribute14 mtl_system_items_b.attribute14%TYPE;
3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;

Line 3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;

3921: l_inventory_attribute15 mtl_system_items_b.attribute15%TYPE;
3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;

Line 3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;

3922: l_inventory_attribute16 mtl_system_items_b.attribute1%TYPE;
3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;

Line 3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;

3923: l_inventory_attribute17 mtl_system_items_b.attribute2%TYPE;
3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;

Line 3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;

3924: l_inventory_attribute18 mtl_system_items_b.attribute3%TYPE;
3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;

Line 3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;

3925: l_inventory_attribute19 mtl_system_items_b.attribute4%TYPE;
3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;

Line 3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;

3926: l_inventory_attribute20 mtl_system_items_b.attribute5%TYPE;
3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;

Line 3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;

3927: l_inventory_attribute21 mtl_system_items_b.attribute6%TYPE;
3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;

Line 3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;

3928: l_inventory_attribute22 mtl_system_items_b.attribute7%TYPE;
3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
3936: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;

Line 3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;

3929: l_inventory_attribute23 mtl_system_items_b.attribute8%TYPE;
3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
3936: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
3937:

Line 3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;

3930: l_inventory_attribute24 mtl_system_items_b.attribute9%TYPE;
3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
3936: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
3937:
3938: BEGIN

Line 3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;

3931: l_inventory_attribute25 mtl_system_items_b.attribute10%TYPE;
3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
3936: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
3937:
3938: BEGIN
3939:

Line 3936: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;

3932: l_inventory_attribute26 mtl_system_items_b.attribute11%TYPE;
3933: l_inventory_attribute27 mtl_system_items_b.attribute12%TYPE;
3934: l_inventory_attribute28 mtl_system_items_b.attribute13%TYPE;
3935: l_inventory_attribute29 mtl_system_items_b.attribute14%TYPE;
3936: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
3937:
3938: BEGIN
3939:
3940: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4026: FROM mtl_system_items_b

4022: l_inventory_attribute27,
4023: l_inventory_attribute28,
4024: l_inventory_attribute29,
4025: l_inventory_attribute30
4026: FROM mtl_system_items_b
4027: WHERE organization_id = p_item_master_org_id--yao zhang modified for bug 7829039
4028: AND inventory_item_id = p_inventory_item_id;
4029: EXCEPTION
4030: WHEN no_data_found THEN

Line 4344: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

4340: --===========================================================================
4341: PROCEDURE Get_Inventory_Item_Number(p_inventory_item_id IN NUMBER,
4342: p_item_master_org_id IN NUMBER,--yao zhang changed fix bug 7829039
4343: x_inventory_item_code OUT NOCOPY VARCHAR2) IS
4344: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
4345: l_procedure_name VARCHAR2(50) := 'get_inventory_item_number';
4346: BEGIN
4347:
4348: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4367: FROM MTL_SYSTEM_ITEMS_B_KFV msv

4363: x_inventory_item_code := NULL;
4364: ELSE
4365: SELECT msv.concatenated_segments
4366: INTO l_inventory_item_code
4367: FROM MTL_SYSTEM_ITEMS_B_KFV msv
4368: WHERE msv.inventory_item_id = p_inventory_item_id--yao zhang changed fix bug 7829039
4369: AND msv.organization_id = p_item_master_org_id;
4370:
4371: -- begin log