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.

[Home] [Help]

APPS.INV_ITEM_PVT dependencies on MTL_STATUS_ATTRIBUTE_VALUES

Line 276: FROM mtl_status_attribute_values

272: WHERE status_control_code IS NOT NULL;
273:
274: CURSOR status_attr_values (p_item_status_code VARCHAR2) IS
275: SELECT attribute_name, attribute_value
276: FROM mtl_status_attribute_values
277: WHERE inventory_item_status_code = p_item_status_code;
278:
279: -- bug 9944329, get org level controlled status attributes
280: CURSOR org_status_attr_values_csr (p_item_status_code VARCHAR2) IS

Line 282: FROM mtl_status_attribute_values status, mtl_item_attributes control

278:
279: -- bug 9944329, get org level controlled status attributes
280: CURSOR org_status_attr_values_csr (p_item_status_code VARCHAR2) IS
281: SELECT status.attribute_name, attribute_value, status_control_code
282: FROM mtl_status_attribute_values status, mtl_item_attributes control
283: WHERE inventory_item_status_code =p_item_status_code
284: AND status.attribute_name = control.attribute_name
285: AND control_level = 2;
286: