VIEW: APPS.JL_AR_AR_CUST_TRX_TYPES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')