no data found in OE_ORDER_HEADERS
i am login using APPS.
select * from dba_synonyms where synonym_name in ('OE_ORDER_HEADERS','OE_ORDER_HEADERS_ALL') and owner='APPS';
OWNER | SYNONYM_NAME | TABLE_OWNER | TABLE_NAME | DB_LINK |
---|---|---|---|---|
APPS | OE_ORDER_HEADERS | ONT | OE_ORDER_HEADERS_ALL | |
APPS | OE_ORDER_HEADERS_ALL | ONT | OE_ORDER_HEADERS_ALL |
select * from apps.oe_order_headers;
no data found.
select * from apps.oe_order_headers_all;
a lot of records.
what's wrong? how to check why the apps.oe_order_headers is not working?