View: FND_DOCUMENT_SEQUENCES_AP_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.FND_DOCUMENT_SEQUENCES_AP_V

View Text

SELECT S.NAME DOC_SEQUENCE_NAME
, S.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DSC.NAME DOC_CATEGORY_NAME
, A.CATEGORY_CODE DOC_CATEGORY_CODE
, DSC.DESCRIPTION DESCRIPTION
, DSC.TABLE_NAME TABLE_NAME
, ASP.ORG_ID
, A.SET_OF_BOOKS_ID
FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
, FND_DOCUMENT_SEQUENCES S
, FND_DOC_SEQUENCE_CATEGORIES DSC
, AP_SYSTEM_PARAMETERS ASP
WHERE (A.METHOD_CODE = 'M' OR A.METHOD_CODE IS NULL)
AND A.APPLICATION_ID = 200
AND (A.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID OR A.SET_OF_BOOKS_ID IS NULL)
AND TRUNC(SYSDATE) BETWEEN NVL(A.START_DATE
, SYSDATE -1)
AND NVL(A.END_DATE
, SYSDATE + 1)
AND A.DOC_SEQUENCE_ID = S.DOC_SEQUENCE_ID|| ' '
AND DSC.APPLICATION_ID = 200
AND DSC.CODE = A.CATEGORY_CODE

Columns