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 10676: FROM OE_LOOKUPS

10672: END IF;
10673:
10674: SELECT 'VALID'
10675: INTO l_dummy
10676: FROM OE_LOOKUPS
10677: WHERE LOOKUP_CODE = p_order_date_type_code
10678: AND LOOKUP_TYPE = l_lookup_type
10679: AND ENABLED_FLAG = 'Y'
10680: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 19037: FROM OE_LOOKUPS

19033: AND ENABLED_FLAG = 'Y';
19034: ELSE
19035: SELECT 'VALID'
19036: INTO l_dummy
19037: FROM OE_LOOKUPS
19038: WHERE LOOKUP_CODE = p_payment_type_code
19039: AND LOOKUP_TYPE = l_lookup_type
19040: AND ENABLED_FLAG = 'Y'
19041: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 19220: FROM OE_LOOKUPS

19216: oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);
19217: END IF;
19218: /*SELECT 'VALID'
19219: INTO l_dummy
19220: FROM OE_LOOKUPS
19221: WHERE LOOKUP_CODE = p_credit_card_code
19222: AND LOOKUP_TYPE = l_lookup_type
19223: AND ENABLED_FLAG = 'Y'
19224: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 20692: FROM OE_LOOKUPS

20688: END IF;
20689:
20690: SELECT 'VALID'
20691: INTO l_dummy
20692: FROM OE_LOOKUPS
20693: WHERE LOOKUP_CODE = p_flow_status_code
20694: AND LOOKUP_TYPE = l_lookup_type
20695: AND ENABLED_FLAG = 'Y'
20696: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 20755: FROM OE_LOOKUPS

20751: END IF;
20752:
20753: SELECT 'VALID'
20754: INTO l_dummy
20755: FROM OE_LOOKUPS
20756: WHERE LOOKUP_CODE = p_flow_status_code
20757: AND LOOKUP_TYPE = l_lookup_type
20758: AND ENABLED_FLAG = 'Y'
20759: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 21151: FROM OE_LOOKUPS

21147: END IF;
21148:
21149: SELECT 'VALID'
21150: INTO l_dummy
21151: FROM OE_LOOKUPS
21152: WHERE LOOKUP_CODE = p_credit_or_charge_flag
21153: AND LOOKUP_TYPE = l_lookup_type
21154: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
21155: AND NVL(END_DATE_ACTIVE, SYSDATE );

Line 21292: FROM OE_LOOKUPS

21288: END IF;
21289:
21290: SELECT 'VALID'
21291: INTO l_dummy
21292: FROM OE_LOOKUPS
21293: WHERE LOOKUP_CODE = p_sales_channel_code
21294: AND LOOKUP_TYPE = l_lookup_type
21295: AND ENABLED_FLAG = 'Y'
21296: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)

Line 21669: FROM OE_LOOKUPS

21665: END IF;
21666:
21667: SELECT 'VALID'
21668: INTO l_dummy
21669: FROM OE_LOOKUPS
21670: WHERE LOOKUP_CODE = p_transaction_phase_code
21671: AND LOOKUP_TYPE = l_lookup_type
21672: AND ENABLED_FLAG = 'Y'
21673: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 21730: FROM OE_LOOKUPS

21726: END IF;
21727:
21728: SELECT 'VALID'
21729: INTO l_dummy
21730: FROM OE_LOOKUPS
21731: WHERE LOOKUP_CODE = p_user_status_code
21732: AND LOOKUP_TYPE = l_lookup_type
21733: AND ENABLED_FLAG = 'Y'
21734: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 21931: FROM OE_LOOKUPS

21927: END IF;
21928:
21929: SELECT 'VALID'
21930: INTO l_dummy
21931: FROM OE_LOOKUPS
21932: WHERE lookup_code = p_ib_owner AND
21933: ( lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
21934:
21935:

Line 21992: FROM OE_LOOKUPS

21988: END IF;
21989:
21990: SELECT 'VALID'
21991: INTO l_dummy
21992: FROM OE_LOOKUPS
21993: WHERE lookup_code = p_ib_installed_at_location AND
21994: (lookup_type = l_lookup_type1 OR lookup_type= l_lookup_type2);
21995:
21996:

Line 22053: FROM OE_LOOKUPS

22049: END IF;
22050:
22051: SELECT 'VALID'
22052: INTO l_dummy
22053: FROM OE_LOOKUPS
22054: WHERE lookup_code = p_ib_current_location AND
22055: (lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
22056:
22057:

Line 23083: FROM OE_LOOKUPS

23079: END IF;
23080:
23081: SELECT 'VALID'
23082: INTO l_dummy
23083: FROM OE_LOOKUPS
23084: WHERE lookup_type = l_lookup_type
23085: AND lookup_code = p_payment_collection_event;
23086:
23087: