APPS.PO_LINES_SV7 dependencies on MTL_SYSTEM_ITEMS

Line 29: mtl_system_items.allow_item_desc_update_flag%TYPE;

25: IS
26: X_progress varchar2(3) := NULL;
27: X_valid BOOLEAN;
28: X_allow_item_desc_update_flag
29: mtl_system_items.allow_item_desc_update_flag%TYPE;
30: X_msi_item_description mtl_system_items.description%TYPE;
31: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
32:
33: BEGIN

Line 30: X_msi_item_description mtl_system_items.description%TYPE;

26: X_progress varchar2(3) := NULL;
27: X_valid BOOLEAN;
28: X_allow_item_desc_update_flag
29: mtl_system_items.allow_item_desc_update_flag%TYPE;
30: X_msi_item_description mtl_system_items.description%TYPE;
31: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
32:
33: BEGIN
34: X_progress := '010';

Line 31: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

27: X_valid BOOLEAN;
28: X_allow_item_desc_update_flag
29: mtl_system_items.allow_item_desc_update_flag%TYPE;
30: X_msi_item_description mtl_system_items.description%TYPE;
31: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
32:
33: BEGIN
34: X_progress := '010';
35: IF (X_item_id is NOT NULL) THEN

Line 41: from mtl_system_items

37:
38: Begin
39: select bom_item_type
40: into l_bom_item_type
41: from mtl_system_items
42: where inventory_item_id = X_item_id
43: and organization_id = X_def_inv_org_id;
44: Exception
45: When others then

Line 134: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc

130: X_progress := '090';
131:
132: /** Bug 5366732 If foreign language is used then item_desc comparision was always
133: Failing because derived value of X_item_description was coming from
134: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc
135: from mtl_system_items_tl **/
136:
137:
138: SELECT msi.allow_item_desc_update_flag,

Line 135: from mtl_system_items_tl **/

131:
132: /** Bug 5366732 If foreign language is used then item_desc comparision was always
133: Failing because derived value of X_item_description was coming from
134: mtl_system_items_tl to keep consistency changing below SQL to fetch item desc
135: from mtl_system_items_tl **/
136:
137:
138: SELECT msi.allow_item_desc_update_flag,
139: mtl.description

Line 142: FROM mtl_system_items msi, mtl_system_items_tl mtl

138: SELECT msi.allow_item_desc_update_flag,
139: mtl.description
140: INTO X_allow_item_desc_update_flag,
141: X_msi_item_description
142: FROM mtl_system_items msi, mtl_system_items_tl mtl
143: WHERE mtl.inventory_item_id = msi.inventory_item_id
144: and mtl.organization_id = msi.organization_id
145: and mtl.language = USERENV('LANG')
146: and mtl.inventory_item_id = X_item_id