Query for GST Document Sequence Form Data Extraction

 

SELECT
JTDS.DOC_SEQ_NAME SEQUENCE_NAME,
JTDS.START_NUMBER,
JTDS.CURRENT_NUMBER,
JTDS.PREFIX,
JTDS.END_NUMBER LAST_NUMBER,
TO_CHAR(JTDS.EFFECTIVE_FROM, 'DD-MON-YYYY') START_DATE,
TO_CHAR(JTDS.EFFECTIVE_TO, 'DD-MON-YYYY') END_DATE,
JTDA.REGIME_NAME,
JTDA.REGISTRATION_NUMBER,
JTDA.ORGANIZATION_TYPE_NAME,
JTDA.ORGANIZATION_NAME,
JTDA.LOCATION_NAME,
JTDA.DOCUMENT_TYPE_CODE,
JTDA.DOCUMENT_CATEGORY_NAME,
JTDA.INTENDED_USE_NAME,
JTDA.RCM_SUPPLY_DAYS,
TO_CHAR(JTDA.EFFECTIVE_FROM, 'DD-MON-YYYY') START_DATE,
TO_CHAR(JTDA.EFFECTIVE_TO, 'DD-MON-YYYY') END_DATE
FROM
APPS.JAI_TAX_DOC_SEQS JTDS,
APPS.JAI_TAX_DOC_SEQ_ASGMT_V JTDA
WHERE
JTDS.DOC_SEQ_ID=JTDA.DOC_SEQ_ID
AND
JTDS.EFFECTIVE_FROM>='01-APR-22'

#oracleebs #oracler12 #ofi #gstdocumentsequence #query #br100 #sql