VIEW: APPS.AP_FND_DOCUMENT_SEQUENCES_QF_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 /* added by Bug 5292805 */ ,FL.MEANING FROM FND_DOC_SEQUENCE_ASSIGNMENTS A, FND_DOCUMENT_SEQUENCES S, FND_DOC_SEQUENCE_CATEGORIES DSC, AP_SYSTEM_PARAMETERS ASP, FND_LOOKUP_VALUES_VL FL WHERE 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) -- Bug 4961902 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 /* Bug 13715993 */ AND FL.LOOKUP_TYPE (+) ='DOCUMENT_SEQUENCE_METHOD_CODE' AND FL.LOOKUP_CODE (+) =A.METHOD_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 /* ADDED BY BUG 5292805 */
, FL.MEANING
FROM FND_DOC_SEQUENCE_ASSIGNMENTS A
, FND_DOCUMENT_SEQUENCES S
, FND_DOC_SEQUENCE_CATEGORIES DSC
, AP_SYSTEM_PARAMETERS ASP
, FND_LOOKUP_VALUES_VL FL
WHERE 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) -- BUG 4961902
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 /* BUG 13715993 */
AND FL.LOOKUP_TYPE (+) ='DOCUMENT_SEQUENCE_METHOD_CODE'
AND FL.LOOKUP_CODE (+) =A.METHOD_CODE