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 5881: From oe_lookups

5877: --12874640 IF p_Item_Identifier_type in ('INT','CUST') THEN
5878: IF p_Item_Identifier_type in ('INT','CUST','CAT') THEN --12874640
5879: Select meaning
5880: Into x_Item_Identifier
5881: From oe_lookups
5882: Where lookup_type = l_lookup_type
5883: And lookup_code = p_Item_Identifier_type;
5884: ELSE
5885: x_Item_Identifier := p_Item_Identifier_type;

Line 5995: FROM OE_LOOKUPS

5991: IF p_user_status_code IS NOT NULL THEN
5992:
5993: SELECT MEANING
5994: INTO l_user_status
5995: FROM OE_LOOKUPS
5996: WHERE LOOKUP_CODE = p_user_status_code
5997: AND LOOKUP_TYPE = l_lookup_type;
5998:
5999:

Line 6055: FROM OE_LOOKUPS

6051: IF p_Transaction_Phase_code IS NOT NULL THEN
6052:
6053: SELECT MEANING
6054: INTO l_Transaction_Phase
6055: FROM OE_LOOKUPS
6056: WHERE LOOKUP_CODE = p_Transaction_Phase_code
6057: AND LOOKUP_TYPE = l_lookup_type;
6058:
6059:

Line 6256: FROM OE_LOOKUPS

6252: IF p_payment_collection_event IS NOT NULL THEN
6253:
6254: SELECT MEANING
6255: INTO l_payment_collection_event
6256: FROM OE_LOOKUPS
6257: WHERE LOOKUP_CODE = p_payment_collection_event
6258: AND LOOKUP_TYPE = l_lookup_type;
6259:
6260: END IF;

Line 6631: FROM OE_LOOKUPS

6627: IF p_ib_owner IS NOT NULL THEN
6628:
6629: SELECT meaning
6630: INTO l_ib_owner_dsp
6631: FROM OE_LOOKUPS
6632: WHERE lookup_code= p_ib_owner and
6633: (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6634:
6635: END IF;

Line 6684: FROM OE_LOOKUPS

6680: IF p_ib_current_location IS NOT NULL THEN
6681:
6682: SELECT meaning
6683: INTO l_ib_current_location_dsp
6684: FROM OE_LOOKUPS
6685: WHERE lookup_code= p_ib_current_location and
6686: (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6687:
6688: END IF;

Line 6737: FROM OE_LOOKUPS

6733: IF p_ib_installed_at_location IS NOT NULL THEN
6734:
6735: SELECT meaning
6736: INTO l_ib_installed_at_location_dsp
6737: FROM OE_LOOKUPS
6738: WHERE lookup_code= p_ib_installed_at_location and
6739: (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6740:
6741: END IF;

Line 6911: FROM oe_lookups

6907: IF p_service_reference_type_code IS NOT NULL THEN
6908:
6909: Select meaning
6910: INTO l_service_reference_type
6911: FROM oe_lookups
6912: WHERE lookup_code=p_service_Reference_type_code
6913: and lookup_type = 'SERVICE_REFERENCE_TYPE_CODE';
6914:
6915: END IF;

Line 6968: FROM OE_LOOKUPS

6964: IF p_change_reason_code IS NOT NULL THEN
6965:
6966: SELECT meaning
6967: INTO l_change_reason
6968: FROM OE_LOOKUPS
6969: WHERE lookup_code= p_change_reason_code
6970: and (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
6971:
6972: END IF;

Line 7214: INTO l_Billing_Option FROM OE_LOOKUPS

7210: --
7211: BEGIN
7212: IF p_service_bill_option_code IS NOT NULL THEN
7213: SELECT MEANING
7214: INTO l_Billing_Option FROM OE_LOOKUPS
7215: WHERE lookup_type='OM_BILLING_OPTION_FOR_SERVICES'
7216: and LOOKUP_CODE = p_service_bill_option_code;
7217: ELSE
7218: l_Billing_Option:= NULL;