View: AP_FND_DOCUMENT_SEQUENCES_QF_V

Product:	AP - Payables
Description:	This is created for using in find window in Invoice Workbench
Implementation/DBA Data:	APPS.AP_FND_DOCUMENT_SEQUENCES_QF_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 /* 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

Columns