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.PN_SOI_VOL_IMPORT dependencies on FND_LOOKUPS

Line 72: fnd_lookups l_channel,

68: lines.period_id ,
69: l_channel.meaning ,
70: l_category.meaning
71: FROM pn_var_lines_all lines,
72: fnd_lookups l_channel,
73: fnd_lookups l_category
74: WHERE lines.line_item_id = p_line_item_id
75: AND l_channel.lookup_code(+) = lines.SALES_TYPE_CODE
76: AND l_channel.lookup_type (+) ='PN_SALES_CHANNEL'

Line 73: fnd_lookups l_category

69: l_channel.meaning ,
70: l_category.meaning
71: FROM pn_var_lines_all lines,
72: fnd_lookups l_channel,
73: fnd_lookups l_category
74: WHERE lines.line_item_id = p_line_item_id
75: AND l_channel.lookup_code(+) = lines.SALES_TYPE_CODE
76: AND l_channel.lookup_type (+) ='PN_SALES_CHANNEL'
77: AND l_category.lookup_code(+) = lines.ITEM_CATEGORY_CODE