View: JL_AR_AR_CUST_TRX_TYPES_V

Product:	JL - Latin America Localizations
Description:
Implementation/DBA Data:	APPS.JL_AR_AR_CUST_TRX_TYPES_V

View Text

SELECT E.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, E.NAME NAME
, E.DESCRIPTION DESCRIPTION
, E.TYPE TYPE
, C.MEANING CLASS_MEANING
, E.ACCOUNTING_AFFECT_FLAG OPEN_RECEIVABLES_FLAG
, E.POST_TO_GL POST_TO_GL_FLAG
, E.ALLOW_FREIGHT_FLAG ALLOW_FREIGHT_FLAG
, E.CREATION_SIGN CREATION_SIGN
, E.ALLOW_OVERAPPLICATION_FLAG ALLOW_OVERAPPLICATION_FLAG
, E.NATURAL_APPLICATION_ONLY_FLAG NATURAL_APPLICATION_ONLY_FLAG
, E.TAX_CALCULATION_FLAG TAX_CALCULATION_FLAG
, B.MEANING DEFAULT_STATUS
, A.MEANING DEFAULT_PRINTING_OPTION
, D.NAME DEFAULT_TERM
, START_DATE
, END_DATE
FROM AR_LOOKUPS A
, AR_LOOKUPS B
, AR_LOOKUPS C
, RA_TERMS D
, RA_CUST_TRX_TYPES E
WHERE 'INVOICE_PRINT_OPTIONS'=A.LOOKUP_TYPE
AND E.DEFAULT_PRINTING_OPTION=A.LOOKUP_CODE
AND 'INVOICE_TRX_STATUS'=B.LOOKUP_TYPE
AND E.DEFAULT_STATUS=B.LOOKUP_CODE
AND E.DEFAULT_TERM=D.TERM_ID(+)
AND 'INV/CM'=C.LOOKUP_TYPE
AND E.TYPE=C.LOOKUP_CODE
AND E.TYPE IN ('DEP'
, 'GUAR'
, 'INV'
, 'CM'
, 'DM')
AND (E.TYPE NOT IN ('DEP'
, 'GUAR') OR E.ACCOUNTING_AFFECT_FLAG='Y')

Columns