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

Line 97: , NVL(p_created_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))

93: , p_bucket_name
94: , p_organization_code
95: , p_inventory_item_code
96: , NVL(p_creation_date, SYSDATE)
97: , NVL(p_created_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
98: , NVL(p_last_update_date, SYSDATE)
99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))

Line 99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))

95: , p_inventory_item_code
96: , NVL(p_creation_date, SYSDATE)
97: , NVL(p_created_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
98: , NVL(p_last_update_date, SYSDATE)
99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))
102: , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))
103: , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))

Line 100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))

96: , NVL(p_creation_date, SYSDATE)
97: , NVL(p_created_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
98: , NVL(p_last_update_date, SYSDATE)
99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))
102: , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))
103: , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))
104: , NVL(p_program_update_date, SYSDATE)

Line 101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))

97: , NVL(p_created_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
98: , NVL(p_last_update_date, SYSDATE)
99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))
102: , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))
103: , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))
104: , NVL(p_program_update_date, SYSDATE)
105: , p_hierarchy_id

Line 102: , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))

98: , NVL(p_last_update_date, SYSDATE)
99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))
102: , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))
103: , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))
104: , NVL(p_program_update_date, SYSDATE)
105: , p_hierarchy_id
106: , p_hierarchy_name

Line 103: , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))

99: , NVL(p_last_updated_by, NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0))
100: , NVL(p_last_update_login, TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')))
101: , NVL(p_request_id, TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID')))
102: , NVL(p_program_application_id,TO_NUMBER(FND_PROFILE.Value('PROG_APPL_ID')))
103: , NVL(p_program_id, TO_NUMBER(FND_PROFILE.Value('CONC_PROG_ID')))
104: , NVL(p_program_update_date, SYSDATE)
105: , p_hierarchy_id
106: , p_hierarchy_name
107: , p_parent_organization_code

Line 155: , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0)

151: UPDATE mtl_mgd_inventory_positions
152: SET last_update_date = NVL(p_last_update_date, SYSDATE)
153: , last_updated_by = NVL
154: ( p_last_updated_by
155: , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0)
156: )
157: , last_update_login = NVL
158: ( p_last_update_login
159: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

Line 159: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

155: , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), 0)
156: )
157: , last_update_login = NVL
158: ( p_last_update_login
159: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
160: )
161: , request_id = NVL
162: ( p_request_id
163: , TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID'))

Line 163: , TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID'))

159: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
160: )
161: , request_id = NVL
162: ( p_request_id
163: , TO_NUMBER(FND_PROFILE.VALUE('CONC_REQ_ID'))
164: )
165: , program_application_id = NVL
166: ( p_program_application_id
167: , TO_NUMBER

Line 168: (FND_PROFILE.Value('PROG_APPL_ID'))

164: )
165: , program_application_id = NVL
166: ( p_program_application_id
167: , TO_NUMBER
168: (FND_PROFILE.Value('PROG_APPL_ID'))
169: )
170: , program_id = NVL
171: ( p_program_id
172: , TO_NUMBER

Line 173: (FND_PROFILE.Value('CONC_PROG_ID'))

169: )
170: , program_id = NVL
171: ( p_program_id
172: , TO_NUMBER
173: (FND_PROFILE.Value('CONC_PROG_ID'))
174: )
175: , program_update_date = NVL(p_program_update_date, SYSDATE)
176: , hierarchy_delta_qty = p_hierarchy_delta_qty
177: , hierarchy_end_on_hand_qty = p_hierarchy_end_on_hand_qty