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 2171: from oe_lookups

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

Line 2481: from oe_lookups

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

Line 2496: from oe_lookups

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

Line 2511: from oe_lookups

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

Line 4385: -- 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

4381: -- added. This holds the list of attributes that can trigger
4382: -- cascading. User can use this look up to disable or enable
4383: -- cascading for any specific attribute.
4384:
4385: -- 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
4386: -- enabled or not for that specific attribute.One field in this
4387: -- record is p_cached which determine whether the record is set
4388: -- or not. So p_cached is used to make sure Read_Cascadable_Fields-- is called only once in a session.
4389:

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

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