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

Line 24: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2

20: AND ((current_organization_id = p_organization_id
21: AND current_status = 1
22: )
23: OR (current_status = 4 AND
24: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2
25: )
26: )
27: AND msn.status_id = mms.status_id(+)
28: AND mms.language (+) = userenv('LANG')

Line 280: AND nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2

276: AND ( ( msn.current_status IN (1, 6)
277: AND msn.current_organization_id = p_organization_id
278: ) OR
279: ( msn.current_status = 4
280: AND nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2
281: ) )
282: AND rsl.shipment_line_status_code <> 'FULLY RECEIVED'
283: AND rsl.to_organization_id = p_organization_id
284: AND rsl.item_id = p_item_id

Line 3907: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3903: p_from_lpn_id IN NUMBER DEFAULT NULL)
3904:
3905: IS
3906:
3907: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3908:
3909: BEGIN
3910:
3911:

Line 3937: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2)

3933: AND ((current_organization_id = p_organization_id
3934: AND current_status = 1
3935: )
3936: OR (current_status = 4 AND
3937: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2)
3938: )
3939: AND msn.status_id = mms.status_id(+)
3940: AND mms.language (+) = userenv('LANG')
3941: AND serial_number LIKE (p_serial)