APPS.OE_VALUE_TO_ID dependencies on OE_LOOKUPS

Line 953: FROM OE_LOOKUPS

949: END IF;
950:
951: SELECT LOOKUP_CODE
952: INTO l_code
953: FROM OE_LOOKUPS
954: WHERE MEANING = p_freight_terms
955: AND LOOKUP_TYPE = l_lookup_type;
956:
957: RETURN l_code;

Line 1851: FROM OE_LOOKUPS

1847: END IF;
1848:
1849: SELECT LOOKUP_CODE
1850: INTO l_code
1851: FROM OE_LOOKUPS
1852: WHERE MEANING = p_shipment_priority
1853: AND LOOKUP_TYPE =l_lookup_type;
1854:
1855: RETURN l_code;

Line 3616: FROM OE_LOOKUPS

3612:
3613: ELSE
3614: SELECT LOOKUP_CODE
3615: INTO l_code
3616: FROM OE_LOOKUPS
3617: WHERE MEANING = p_payment_type
3618: AND LOOKUP_TYPE = l_lookup_type;
3619: END IF;
3620: --serla end

Line 5960: FROM OE_LOOKUPS

5956: END IF;
5957:
5958: SELECT distinct LOOKUP_CODE
5959: INTO l_code
5960: FROM OE_LOOKUPS
5961: WHERE (lookup_type = 'FLOW_STATUS'
5962: OR lookup_type = 'LINE_FLOW_STATUS')
5963: AND meaning = p_flow_status;
5964:

Line 6064: FROM OE_LOOKUPS

6060: END IF;
6061:
6062: SELECT LOOKUP_CODE
6063: INTO l_code
6064: FROM OE_LOOKUPS
6065: WHERE LOOKUP_TYPE = l_lookup_type
6066: AND MEANING = p_sales_channel;
6067:
6068: RETURN l_code;

Line 6216: FROM OE_LOOKUPS

6212: END IF;
6213:
6214: SELECT LOOKUP_CODE
6215: INTO l_code
6216: FROM OE_LOOKUPS
6217: WHERE LOOKUP_TYPE = l_lookup_type
6218: AND MEANING = p_payment_collection_event;
6219:
6220: RETURN l_code;

Line 6693: FROM OE_LOOKUPS

6689: END IF;
6690:
6691: SELECT LOOKUP_CODE
6692: INTO l_code
6693: FROM OE_LOOKUPS
6694: WHERE MEANING = p_ib_owner
6695: AND LOOKUP_TYPE = l_lookup_type1 ;--or LOOKUP_TYPE = l_lookup_type1);
6696:
6697: RETURN l_code;

Line 6748: FROM OE_LOOKUPS

6744: END IF;
6745:
6746: SELECT LOOKUP_CODE
6747: INTO l_code
6748: FROM OE_LOOKUPS
6749: WHERE MEANING = p_ib_installed_at_location
6750: AND LOOKUP_TYPE = l_lookup_type1; -- or LOOKUP_TYPE = l_lookup_type1);
6751: oe_Debug_pub.add('ib inst code'||l_code);
6752: RETURN l_code;

Line 6803: FROM OE_LOOKUPS

6799: END IF;
6800:
6801: SELECT LOOKUP_CODE
6802: INTO l_code
6803: FROM OE_LOOKUPS
6804: WHERE MEANING = p_ib_current_location
6805: AND LOOKUP_TYPE = l_lookup_type1 ;--or LOOKUP_TYPE = l_lookup_type1);
6806:
6807: RETURN l_code;