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.OE_OE_FORM_HEADER dependencies on OE_LOOKUPS

Line 2172: from oe_lookups

2168: IF (p_header_rec_type.order_date_type_code is not null) THEN
2169: BEGIN
2170: select meaning
2171: into x_header_val_rec.order_date_type
2172: from oe_lookups
2173: where lookup_type = 'REQUEST_DATE_TYPE'
2174: AND lookup_code=p_header_rec_type.order_date_type_code;
2175:
2176: EXCEPTION

Line 2482: from oe_lookups

2478: --Macd
2479: IF (p_header_rec_type.ib_owner is not null) THEN
2480: BEGIN
2481: select meaning into x_header_val_rec.ib_owner_dsp
2482: from oe_lookups
2483: where lookup_type='ITEM_OWNER' and lookup_code=p_header_rec_type.ib_owner;
2484: EXCEPTION
2485: WHEN NO_DATA_FOUND THEN
2486: Null;

Line 2497: from oe_lookups

2493:
2494: IF (p_header_rec_type.ib_installed_at_location is not null) THEN
2495: BEGIN
2496: select meaning into x_header_val_rec.ib_installed_at_location_dsp
2497: from oe_lookups
2498: where lookup_type='ITEM_INSTALL_LOCATION' and lookup_code=p_header_rec_type.ib_installed_at_location;
2499: EXCEPTION
2500: WHEN NO_DATA_FOUND THEN
2501: Null;

Line 2512: from oe_lookups

2508:
2509: IF (p_header_rec_type.ib_current_location is not null) THEN
2510: BEGIN
2511: select meaning into x_header_val_rec.ib_current_location_dsp
2512: from oe_lookups
2513: where lookup_type='ITEM_CURRENT_LOCATION' and lookup_code=p_header_rec_type.ib_current_location;
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: Null;

Line 4388: -- Read_Cascadable_Fields queries the enabled_flag from oe_lookups-- for each such attributes and store them in a record. Fields of -- this record will be used to determine whether cascading is

4384: -- added. This holds the list of attributes that can trigger
4385: -- cascading. User can use this look up to disable or enable
4386: -- cascading for any specific attribute.
4387:
4388: -- Read_Cascadable_Fields queries the enabled_flag from oe_lookups-- for each such attributes and store them in a record. Fields of -- this record will be used to determine whether cascading is
4389: -- enabled or not for that specific attribute.One field in this
4390: -- record is p_cached which determine whether the record is set
4391: -- or not. So p_cached is used to make sure Read_Cascadable_Fields-- is called only once in a session.
4392:

Line 4406: Select enabled_flag from oe_lookups where lookup_type=p_lookup_type1 and lookup_code=p_lookup_code1;

4402: l_enabled_flag Varchar2(1);
4403: p_cascade_record OE_OE_FORM_HEADER.Cascade_record;
4404:
4405: Cursor C_LOOKUP (p_lookup_code1 Varchar2, p_lookup_type1 Varchar2) IS
4406: Select enabled_flag from oe_lookups where lookup_type=p_lookup_type1 and lookup_code=p_lookup_code1;
4407:
4408:
4409: BEGIN
4410: