VIEW: APPS.FND_DOCUMENT_SEQUENCES_AP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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