Extracting data from a different Schema from JDE UBE
Hi Mentors,
I have a requirement where i need to retrieve data using JDE report from a different Schema which resides in same database as our JDE. How do we do that? Can we use Table conversion for the same? What other options do we have?
eg:
Table in Other Schema: xxapps.xxDEF_ABC_qa_headers
Below is the table structure
Name Null Type
----------------- -------- --------------
QA_HEADER_ID NOT NULL NUMBER
CUSTOMER_ID NUMBER
ITEM_ID NUMBER
SERIAL_NUMBER VARCHAR2(30)
CASE_NUMBER NUMBER
WORK_ORDER_NUMBER NUMBER
OPERATION_ID NUMBER
OPERATION_SEQ NUMBER
HEADER_STATUS VARCHAR2(10)
CREATION_DATE DATE