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_BULK_VALIDATE dependencies on OE_AR_LOOKUPS_V

Line 585: FROM OE_AR_LOOKUPS_V

581: FROM OE_HEADERS_IFACE_ALL b
582: WHERE batch_id = p_batch_id and
583: b.fob_point_code IS NOT NULL and
584: NOT EXISTS (SELECT LOOKUP_CODE
585: FROM OE_AR_LOOKUPS_V
586: WHERE LOOKUP_CODE = b.fob_point_code
587: AND LOOKUP_TYPE = 'FOB'
588: AND ENABLED_FLAG = 'Y'
589: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 627: FROM OE_AR_LOOKUPS_V

623: FROM OE_HEADERS_IFACE_ALL
624: WHERE batch_id = p_batch_id)
625: AND b.fob_point_code IS NOT NULL and
626: NOT EXISTS (SELECT LOOKUP_CODE
627: FROM OE_AR_LOOKUPS_V
628: WHERE LOOKUP_CODE = b.fob_point_code
629: AND LOOKUP_TYPE = 'FOB'
630: AND ENABLED_FLAG = 'Y'
631: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1252: FROM OE_AR_LOOKUPS_V

1248: FROM OE_HEADERS_IFACE_ALL b
1249: WHERE batch_id = p_batch_id and
1250: b.tax_exempt_flag IS NOT NULL and
1251: NOT EXISTS (SELECT LOOKUP_CODE
1252: FROM OE_AR_LOOKUPS_V
1253: WHERE LOOKUP_CODE = b.tax_exempt_flag
1254: AND LOOKUP_TYPE = 'TAX_CONTROL_FLAG'
1255: AND ENABLED_FLAG = 'Y'
1256: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1293: FROM OE_AR_LOOKUPS_V

1289: FROM OE_HEADERS_IFACE_ALL
1290: WHERE batch_id = p_batch_id)
1291: AND b.tax_exempt_flag IS NOT NULL and
1292: NOT EXISTS (SELECT LOOKUP_CODE
1293: FROM OE_AR_LOOKUPS_V
1294: WHERE LOOKUP_CODE = b.tax_exempt_flag
1295: AND LOOKUP_TYPE = 'TAX_CONTROL_FLAG'
1296: AND ENABLED_FLAG = 'Y'
1297: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)