APPS.OE_CNCL_VALUE_TO_ID dependencies on OE_LOOKUPS

Line 646: FROM OE_LOOKUPS

642: END IF;
643:
644: SELECT LOOKUP_CODE
645: INTO l_code
646: FROM OE_LOOKUPS
647: WHERE MEANING = p_freight_terms
648: AND LOOKUP_TYPE = l_lookup_type;
649:
650: RETURN l_code;

Line 1505: FROM OE_LOOKUPS

1501: END IF;
1502:
1503: SELECT LOOKUP_CODE
1504: INTO l_code
1505: FROM OE_LOOKUPS
1506: WHERE MEANING = p_shipment_priority
1507: AND LOOKUP_TYPE = l_lookup_type;
1508:
1509: RETURN l_code;

Line 3017: FROM OE_LOOKUPS

3013: END IF;
3014:
3015: SELECT LOOKUP_CODE
3016: INTO l_code
3017: FROM OE_LOOKUPS
3018: WHERE MEANING = p_payment_type
3019: AND LOOKUP_TYPE = l_lookup_type;
3020:
3021: RETURN l_code;

Line 3069: FROM OE_LOOKUPS

3065: END IF;
3066:
3067: SELECT LOOKUP_CODE
3068: INTO l_code
3069: FROM OE_LOOKUPS
3070: WHERE MEANING = p_credit_card
3071: AND LOOKUP_TYPE = l_lookup_type;
3072:
3073: RETURN l_code;

Line 5187: FROM OE_LOOKUPS

5183: END IF;
5184:
5185: SELECT distinct LOOKUP_CODE
5186: INTO l_code
5187: FROM OE_LOOKUPS
5188: WHERE (lookup_type = 'FLOW_STATUS'
5189: OR lookup_type = 'LINE_FLOW_STATUS')
5190: AND meaning = p_flow_status;
5191:

Line 5298: FROM OE_LOOKUPS

5294: END IF;
5295:
5296: SELECT LOOKUP_CODE
5297: INTO l_code
5298: FROM OE_LOOKUPS
5299: WHERE LOOKUP_TYPE = l_lookup_type
5300: AND MEANING = p_sales_channel;
5301:
5302: RETURN l_code;

Line 5817: FROM OE_LOOKUPS

5813: END IF;
5814:
5815: SELECT LOOKUP_CODE
5816: INTO l_code
5817: FROM OE_LOOKUPS
5818: WHERE MEANING = p_ib_owner
5819: AND LOOKUP_TYPE = l_lookup_type1;-- or LOOKUP_TYPE = l_lookup_type1);
5820: oe_Debug_pub.add('Code value found is'||l_code);
5821: RETURN l_code;

Line 5872: FROM OE_LOOKUPS

5868: END IF;
5869:
5870: SELECT LOOKUP_CODE
5871: INTO l_code
5872: FROM OE_LOOKUPS
5873: WHERE MEANING = p_ib_installed_at_location
5874: AND LOOKUP_TYPE = l_lookup_type1;-- or LOOKUP_TYPE = l_lookup_type1);
5875:
5876: RETURN l_code;

Line 5927: FROM OE_LOOKUPS

5923: END IF;
5924:
5925: SELECT LOOKUP_CODE
5926: INTO l_code
5927: FROM OE_LOOKUPS
5928: WHERE MEANING = p_ib_current_location
5929: AND LOOKUP_TYPE = l_lookup_type1;-- or LOOKUP_TYPE = l_lookup_type1);
5930:
5931: RETURN l_code;