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.INVUPDAT dependencies on FND_PROFILE

Line 66: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

62: if ( current_attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG') then
63: update mtl_system_items msi
64: set msi.stock_enabled_flag
65: = NVL(current_attribute_value, status_cursor_row.AV),
66: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
67: msi.last_update_date = sysdate,
68: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
69: where msi.inventory_item_flag = 'Y'
70: and msi.stock_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 68: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

64: set msi.stock_enabled_flag
65: = NVL(current_attribute_value, status_cursor_row.AV),
66: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
67: msi.last_update_date = sysdate,
68: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
69: where msi.inventory_item_flag = 'Y'
70: and msi.stock_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
71: and msi.inventory_item_status_code = status_cursor_row.IISC;
72:

Line 77: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

73: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG') then
74: update mtl_system_items msi
75: set msi.mtl_transactions_enabled_flag
76: = NVL(current_attribute_value, status_cursor_row.AV),
77: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
78: msi.last_update_date = sysdate,
79: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
80: where msi.stock_enabled_flag = 'Y'
81: and msi.mtl_transactions_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 79: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

75: set msi.mtl_transactions_enabled_flag
76: = NVL(current_attribute_value, status_cursor_row.AV),
77: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
78: msi.last_update_date = sysdate,
79: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
80: where msi.stock_enabled_flag = 'Y'
81: and msi.mtl_transactions_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
82: and msi.inventory_item_status_code = status_cursor_row.IISC;
83:

Line 88: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

84: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG') then
85: update mtl_system_items msi
86: set msi.purchasing_enabled_flag
87: = NVL(current_attribute_value, status_cursor_row.AV),
88: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
89: msi.last_update_date = sysdate,
90: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
91: where msi.purchasing_item_flag = 'Y'
92: and msi.purchasing_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 90: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

86: set msi.purchasing_enabled_flag
87: = NVL(current_attribute_value, status_cursor_row.AV),
88: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
89: msi.last_update_date = sysdate,
90: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
91: where msi.purchasing_item_flag = 'Y'
92: and msi.purchasing_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
93: and msi.inventory_item_status_code = status_cursor_row.IISC;
94:

Line 99: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

95: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG') then
96: update mtl_system_items msi
97: set msi.invoice_enabled_flag
98: = NVL(current_attribute_value, status_cursor_row.AV),
99: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
100: msi.last_update_date = sysdate,
101: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
102: where msi.invoiceable_item_flag = 'Y'
103: and msi.invoice_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 101: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

97: set msi.invoice_enabled_flag
98: = NVL(current_attribute_value, status_cursor_row.AV),
99: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
100: msi.last_update_date = sysdate,
101: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
102: where msi.invoiceable_item_flag = 'Y'
103: and msi.invoice_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
104: and msi.inventory_item_status_code = status_cursor_row.IISC;
105:

Line 110: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

106: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG') then
107: update mtl_system_items msi
108: set msi.build_in_wip_flag
109: = NVL(current_attribute_value, status_cursor_row.AV),
110: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
111: msi.last_update_date = sysdate,
112: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
113: where msi.inventory_item_flag = 'Y'
114: and msi.build_in_wip_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 112: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

108: set msi.build_in_wip_flag
109: = NVL(current_attribute_value, status_cursor_row.AV),
110: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
111: msi.last_update_date = sysdate,
112: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
113: where msi.inventory_item_flag = 'Y'
114: and msi.build_in_wip_flag <> NVL(current_attribute_value, status_cursor_row.AV)
115: and msi.bom_item_type = 4
116: and msi.inventory_item_status_code = status_cursor_row.IISC;

Line 122: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

118: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG') then
119: update mtl_system_items msi
120: set msi.customer_order_enabled_flag
121: = NVL(current_attribute_value, status_cursor_row.AV),
122: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
123: msi.last_update_date = sysdate,
124: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
125: where msi.customer_order_flag = 'Y'
126: and msi.customer_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 124: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

120: set msi.customer_order_enabled_flag
121: = NVL(current_attribute_value, status_cursor_row.AV),
122: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
123: msi.last_update_date = sysdate,
124: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
125: where msi.customer_order_flag = 'Y'
126: and msi.customer_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
127: and msi.inventory_item_status_code = status_cursor_row.IISC;
128:

Line 133: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

129: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG') then
130: update mtl_system_items msi
131: set msi.internal_order_enabled_flag
132: = NVL(current_attribute_value, status_cursor_row.AV),
133: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
134: msi.last_update_date = sysdate,
135: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
136: where msi.internal_order_flag = 'Y'
137: and msi.internal_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 135: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

131: set msi.internal_order_enabled_flag
132: = NVL(current_attribute_value, status_cursor_row.AV),
133: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
134: msi.last_update_date = sysdate,
135: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
136: where msi.internal_order_flag = 'Y'
137: and msi.internal_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
138: and msi.inventory_item_status_code = status_cursor_row.IISC;
139:

Line 144: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

140: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG') then
141: update mtl_system_items msi
142: set msi.bom_enabled_flag
143: = NVL(current_attribute_value, status_cursor_row.AV),
144: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
145: msi.last_update_date = sysdate,
146: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
147: where --Bug: 3546140 msi.inventory_item_flag = 'Y'and
148: msi.bom_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)

Line 146: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

142: set msi.bom_enabled_flag
143: = NVL(current_attribute_value, status_cursor_row.AV),
144: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
145: msi.last_update_date = sysdate,
146: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
147: where --Bug: 3546140 msi.inventory_item_flag = 'Y'and
148: msi.bom_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
149: and msi.inventory_item_status_code = status_cursor_row.IISC;
150: /* Jalaj Srivastava Bug 4032615 */

Line 155: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

151: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG') then
152: update mtl_system_items msi
153: set msi.recipe_enabled_flag
154: = NVL(current_attribute_value, status_cursor_row.AV),
155: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
156: msi.last_update_date = sysdate,
157: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
158: where msi.recipe_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
159: and msi.inventory_item_status_code = status_cursor_row.IISC;

Line 157: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

153: set msi.recipe_enabled_flag
154: = NVL(current_attribute_value, status_cursor_row.AV),
155: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
156: msi.last_update_date = sysdate,
157: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
158: where msi.recipe_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
159: and msi.inventory_item_status_code = status_cursor_row.IISC;
160:
161: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG') then

Line 165: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

161: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG') then
162: update mtl_system_items msi
163: set msi.process_execution_enabled_flag
164: = NVL(current_attribute_value, status_cursor_row.AV),
165: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
166: msi.last_update_date = sysdate,
167: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
168: where msi.process_execution_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
169: and msi.inventory_item_status_code = status_cursor_row.IISC;

Line 167: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))

163: set msi.process_execution_enabled_flag
164: = NVL(current_attribute_value, status_cursor_row.AV),
165: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
166: msi.last_update_date = sysdate,
167: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
168: where msi.process_execution_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
169: and msi.inventory_item_status_code = status_cursor_row.IISC;
170:
171: end if;