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

Line 1153: FROM OE_LOOKUPS

1149: END IF;
1150:
1151: SELECT 'VALID'
1152: INTO l_dummy
1153: FROM OE_LOOKUPS
1154: WHERE LOOKUP_CODE = p_source_type_code
1155: AND LOOKUP_TYPE = l_lookup_type
1156: AND ENABLED_FLAG = 'Y'
1157: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1438: FROM OE_LOOKUPS

1434:
1435:
1436: SELECT 'VALID'
1437: INTO l_dummy
1438: FROM OE_LOOKUPS
1439: WHERE LOOKUP_CODE = p_shipment_priority_code
1440: AND LOOKUP_TYPE = l_lookup_type
1441: AND ENABLED_FLAG = 'Y'
1442: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 2795: FROM OE_LOOKUPS

2791: END IF;
2792:
2793: SELECT 'VALID'
2794: INTO l_dummy
2795: FROM OE_LOOKUPS
2796: WHERE LOOKUP_CODE = p_tax_point_code
2797: AND LOOKUP_TYPE = l_lookup_type
2798: AND ENABLED_FLAG = 'Y'
2799: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 3293: FROM OE_LOOKUPS

3289: END IF;
3290:
3291: SELECT 'VALID'
3292: INTO l_dummy
3293: FROM OE_LOOKUPS
3294: WHERE LOOKUP_CODE = p_freight_terms_code
3295: AND LOOKUP_TYPE = l_lookup_type
3296: AND ENABLED_FLAG = 'Y'
3297: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 5317: FROM OE_LOOKUPS

5313: END IF;
5314:
5315: SELECT 'VALID'
5316: INTO l_dummy
5317: FROM OE_LOOKUPS
5318: WHERE LOOKUP_CODE = p_change_reason_code
5319: AND LOOKUP_TYPE = l_lookup_type
5320: AND ENABLED_FLAG = 'Y'
5321: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);

Line 10410: FROM OE_LOOKUPS

10406: RETURN TRUE;
10407: END IF;
10408: SELECT 'Y'
10409: into l_exists
10410: FROM OE_LOOKUPS
10411: WHERE lookup_type='OM_BILLING_OPTION_FOR_SERVICES'
10412: AND enabled_flag='Y'
10413: AND LOOKUP_CODE =p_service_bill_option_code;
10414: RETURN TRUE;

Line 10870: FROM OE_LOOKUPS

10866: END IF;
10867:
10868: SELECT 'VALID'
10869: INTO l_dummy
10870: FROM OE_LOOKUPS
10871: WHERE LOOKUP_CODE = p_order_date_type_code
10872: AND LOOKUP_TYPE = l_lookup_type
10873: AND ENABLED_FLAG = 'Y'
10874: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 19231: FROM OE_LOOKUPS

19227: AND ENABLED_FLAG = 'Y';
19228: ELSE
19229: SELECT 'VALID'
19230: INTO l_dummy
19231: FROM OE_LOOKUPS
19232: WHERE LOOKUP_CODE = p_payment_type_code
19233: AND LOOKUP_TYPE = l_lookup_type
19234: AND ENABLED_FLAG = 'Y'
19235: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 19414: FROM OE_LOOKUPS

19410: --oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);
19411: --END IF;
19412: /*SELECT 'VALID'
19413: INTO l_dummy
19414: FROM OE_LOOKUPS
19415: WHERE LOOKUP_CODE = p_credit_card_code
19416: AND LOOKUP_TYPE = l_lookup_type
19417: AND ENABLED_FLAG = 'Y'
19418: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 20886: FROM OE_LOOKUPS

20882: END IF;
20883:
20884: SELECT 'VALID'
20885: INTO l_dummy
20886: FROM OE_LOOKUPS
20887: WHERE LOOKUP_CODE = p_flow_status_code
20888: AND LOOKUP_TYPE = l_lookup_type
20889: AND ENABLED_FLAG = 'Y'
20890: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 20949: FROM OE_LOOKUPS

20945: END IF;
20946:
20947: SELECT 'VALID'
20948: INTO l_dummy
20949: FROM OE_LOOKUPS
20950: WHERE LOOKUP_CODE = p_flow_status_code
20951: AND LOOKUP_TYPE = l_lookup_type
20952: AND ENABLED_FLAG = 'Y'
20953: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 21345: FROM OE_LOOKUPS

21341: END IF;
21342:
21343: SELECT 'VALID'
21344: INTO l_dummy
21345: FROM OE_LOOKUPS
21346: WHERE LOOKUP_CODE = p_credit_or_charge_flag
21347: AND LOOKUP_TYPE = l_lookup_type
21348: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
21349: AND NVL(END_DATE_ACTIVE, SYSDATE );

Line 21486: FROM OE_LOOKUPS

21482: END IF;
21483:
21484: SELECT 'VALID'
21485: INTO l_dummy
21486: FROM OE_LOOKUPS
21487: WHERE LOOKUP_CODE = p_sales_channel_code
21488: AND LOOKUP_TYPE = l_lookup_type
21489: AND ENABLED_FLAG = 'Y'
21490: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)

Line 21863: FROM OE_LOOKUPS

21859: END IF;
21860:
21861: SELECT 'VALID'
21862: INTO l_dummy
21863: FROM OE_LOOKUPS
21864: WHERE LOOKUP_CODE = p_transaction_phase_code
21865: AND LOOKUP_TYPE = l_lookup_type
21866: AND ENABLED_FLAG = 'Y'
21867: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 21924: FROM OE_LOOKUPS

21920: END IF;
21921:
21922: SELECT 'VALID'
21923: INTO l_dummy
21924: FROM OE_LOOKUPS
21925: WHERE LOOKUP_CODE = p_user_status_code
21926: AND LOOKUP_TYPE = l_lookup_type
21927: AND ENABLED_FLAG = 'Y'
21928: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 22125: FROM OE_LOOKUPS

22121: END IF;
22122:
22123: SELECT 'VALID'
22124: INTO l_dummy
22125: FROM OE_LOOKUPS
22126: WHERE lookup_code = p_ib_owner AND
22127: ( lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
22128:
22129:

Line 22186: FROM OE_LOOKUPS

22182: END IF;
22183:
22184: SELECT 'VALID'
22185: INTO l_dummy
22186: FROM OE_LOOKUPS
22187: WHERE lookup_code = p_ib_installed_at_location AND
22188: (lookup_type = l_lookup_type1 OR lookup_type= l_lookup_type2);
22189:
22190:

Line 22247: FROM OE_LOOKUPS

22243: END IF;
22244:
22245: SELECT 'VALID'
22246: INTO l_dummy
22247: FROM OE_LOOKUPS
22248: WHERE lookup_code = p_ib_current_location AND
22249: (lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
22250:
22251:

Line 23277: FROM OE_LOOKUPS

23273: END IF;
23274:
23275: SELECT 'VALID'
23276: INTO l_dummy
23277: FROM OE_LOOKUPS
23278: WHERE lookup_type = l_lookup_type
23279: AND lookup_code = p_payment_collection_event;
23280:
23281: