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_ID_TO_VALUE dependencies on OE_LOOKUPS

Line 323: FROM OE_LOOKUPS

319: IF p_calculate_price_flag IS NOT NULL THEN
320:
321: SELECT MEANING
322: INTO l_calculate_price_flag
323: FROM OE_LOOKUPS
324: WHERE LOOKUP_CODE = p_calculate_price_flag
325: AND LOOKUP_TYPE = l_lookup_type;
326:
327:

Line 737: FROM OE_LOOKUPS

733: IF p_freight_terms_code IS NOT NULL THEN
734:
735: SELECT MEANING
736: INTO l_freight_terms
737: FROM OE_LOOKUPS
738: WHERE LOOKUP_CODE = p_freight_terms_code
739: AND LOOKUP_TYPE = l_lookup_type;
740:
741: END IF;

Line 1437: FROM OE_LOOKUPS

1433: IF p_shipment_priority_code IS NOT NULL THEN
1434:
1435: SELECT MEANING
1436: INTO l_shipment_priority
1437: FROM OE_LOOKUPS
1438: WHERE LOOKUP_CODE = p_shipment_priority_code
1439: AND LOOKUP_TYPE = l_lookup_type;
1440:
1441: END IF;

Line 2679: FROM OE_LOOKUPS

2675: IF p_source_type_code IS NOT NULL THEN
2676:
2677: SELECT MEANING
2678: INTO l_source_type
2679: FROM OE_LOOKUPS
2680: WHERE LOOKUP_CODE = p_source_type_code
2681: AND LOOKUP_TYPE = l_lookup_type;
2682:
2683: END IF;

Line 2731: FROM OE_LOOKUPS

2727: IF p_order_date_type_code IS NOT NULL THEN
2728:
2729: SELECT MEANING
2730: INTO l_order_date_type
2731: FROM OE_LOOKUPS
2732: WHERE LOOKUP_CODE = p_order_date_type_code
2733: AND LOOKUP_TYPE = l_lookup_type;
2734:
2735: END IF;

Line 3070: FROM oe_lookups

3066: IF ( p_payment_type_code = 'COMMITMENT') THEN
3067: l_lookup_type :='OE_PAYMENT_TYPE';
3068: SELECT MEANING
3069: INTO l_payment_type
3070: FROM oe_lookups
3071: WHERE lookup_type=l_lookup_type and lookup_code=p_payment_type_code;
3072: ELSE
3073: SELECT NAME
3074: INTO l_payment_type

Line 3081: FROM OE_LOOKUPS

3077: END IF;
3078: ELSE
3079: SELECT MEANING
3080: INTO l_payment_type
3081: FROM OE_LOOKUPS
3082: WHERE LOOKUP_CODE = p_payment_type_code
3083: AND LOOKUP_TYPE = l_lookup_type;
3084: END IF;
3085: --serla end

Line 5425: FROM OE_LOOKUPS

5421: IF p_flow_status_code IS NOT NULL THEN
5422:
5423: SELECT distinct MEANING
5424: INTO l_flow_status
5425: FROM OE_LOOKUPS
5426: WHERE LOOKUP_CODE = p_flow_status_code
5427: AND (LOOKUP_TYPE = l_lookup_type1
5428: OR LOOKUP_TYPE = l_lookup_type2);
5429:

Line 5541: FROM OE_LOOKUPS

5537: IF p_sales_channel_code IS NOT NULL THEN
5538:
5539: SELECT MEANING
5540: INTO l_sales_channel
5541: FROM OE_LOOKUPS
5542: WHERE LOOKUP_CODE = p_sales_channel_code
5543: AND LOOKUP_TYPE = l_lookup_type;
5544:
5545: END IF;

Line 5855: From oe_lookups

5851: END IF;
5852: IF p_Item_Identifier_type in ('INT','CUST') THEN
5853: Select meaning
5854: Into x_Item_Identifier
5855: From oe_lookups
5856: Where lookup_type = l_lookup_type
5857: And lookup_code = p_Item_Identifier_type;
5858: ELSE
5859: x_Item_Identifier := p_Item_Identifier_type;

Line 5969: FROM OE_LOOKUPS

5965: IF p_user_status_code IS NOT NULL THEN
5966:
5967: SELECT MEANING
5968: INTO l_user_status
5969: FROM OE_LOOKUPS
5970: WHERE LOOKUP_CODE = p_user_status_code
5971: AND LOOKUP_TYPE = l_lookup_type;
5972:
5973:

Line 6029: FROM OE_LOOKUPS

6025: IF p_Transaction_Phase_code IS NOT NULL THEN
6026:
6027: SELECT MEANING
6028: INTO l_Transaction_Phase
6029: FROM OE_LOOKUPS
6030: WHERE LOOKUP_CODE = p_Transaction_Phase_code
6031: AND LOOKUP_TYPE = l_lookup_type;
6032:
6033:

Line 6230: FROM OE_LOOKUPS

6226: IF p_payment_collection_event IS NOT NULL THEN
6227:
6228: SELECT MEANING
6229: INTO l_payment_collection_event
6230: FROM OE_LOOKUPS
6231: WHERE LOOKUP_CODE = p_payment_collection_event
6232: AND LOOKUP_TYPE = l_lookup_type;
6233:
6234: END IF;

Line 6605: FROM OE_LOOKUPS

6601: IF p_ib_owner IS NOT NULL THEN
6602:
6603: SELECT meaning
6604: INTO l_ib_owner_dsp
6605: FROM OE_LOOKUPS
6606: WHERE lookup_code= p_ib_owner and
6607: (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6608:
6609: END IF;

Line 6658: FROM OE_LOOKUPS

6654: IF p_ib_current_location IS NOT NULL THEN
6655:
6656: SELECT meaning
6657: INTO l_ib_current_location_dsp
6658: FROM OE_LOOKUPS
6659: WHERE lookup_code= p_ib_current_location and
6660: (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6661:
6662: END IF;

Line 6711: FROM OE_LOOKUPS

6707: IF p_ib_installed_at_location IS NOT NULL THEN
6708:
6709: SELECT meaning
6710: INTO l_ib_installed_at_location_dsp
6711: FROM OE_LOOKUPS
6712: WHERE lookup_code= p_ib_installed_at_location and
6713: (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6714:
6715: END IF;

Line 6885: FROM oe_lookups

6881: IF p_service_reference_type_code IS NOT NULL THEN
6882:
6883: Select meaning
6884: INTO l_service_reference_type
6885: FROM oe_lookups
6886: WHERE lookup_code=p_service_Reference_type_code
6887: and lookup_type = 'SERVICE_REFERENCE_TYPE_CODE';
6888:
6889: END IF;

Line 6942: FROM OE_LOOKUPS

6938: IF p_change_reason_code IS NOT NULL THEN
6939:
6940: SELECT meaning
6941: INTO l_change_reason
6942: FROM OE_LOOKUPS
6943: WHERE lookup_code= p_change_reason_code
6944: and (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6945:
6946: END IF;