VIEW: APPS.ARFV_FREIGHT_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ TLGD.CUST_TRX_LINE_GL_DIST_ID , /* REGULAR ATTRIBUTES */ '_LA:TLGD.ACCOUNT_CLASS:AR_LOOKUPS:AUTOGL_TYPE:MEANING' , DECODE(SIGN(TLGD.AMOUNT), -1, ABS(TLGD.AMOUNT), NULL) , DECODE(SIGN(TLGD.AMOUNT), 1, TLGD.AMOUNT, NULL) , DECODE(SIGN(TLGD.ACCTD_AMOUNT), -1, ABS(TLGD.ACCTD_AMOUNT), NULL) , DECODE(SIGN(TLGD.ACCTD_AMOUNT), 1, TLGD.ACCTD_AMOUNT, NULL) , TLGD.GL_DATE , '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE,   ''Y'',   ''Y'',   ''N''):AR_LOOKUPS:YES/NO:MEANING' , '_DF:AR:RA_CUST_TRX_LINE_GL_DIST:TLGD' , /* RESOLVED FK RESOLUTIONS */ CT.TRX_NUMBER , CTL.LINE_NUMBER , '_KF:SQLGL:GL#:GCC' , AOU.NAME , /* IDS */ TLGD.CUSTOMER_TRX_ID , TLGD.CUSTOMER_TRX_LINE_ID , TLGD.CODE_COMBINATION_ID , TLGD.ORG_ID , /* WHO COLUMNS */ TLGD.LAST_UPDATE_DATE , TLGD.LAST_UPDATED_BY , TLGD.CREATION_DATE , TLGD.CREATED_BY FROM AR_XLA_CTLGD_LINES_V TLGD, RA_CUSTOMER_TRX CT, RA_CUSTOMER_TRX_LINES CTL, GL_CODE_COMBINATIONS GCC, HR_ALL_ORGANIZATION_UNITS AOU, XLA_AE_HEADERS HED WHERE TLGD.ACCOUNT_CLASS = 'FREIGHT' AND TLGD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+) AND TLGD.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID (+) AND TLGD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+) AND TLGD.ORG_ID = AOU.ORGANIZATION_ID(+) AND TLGD.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ TLGD.CUST_TRX_LINE_GL_DIST_ID
, /* REGULAR ATTRIBUTES */ '_LA:TLGD.ACCOUNT_CLASS:AR_LOOKUPS:AUTOGL_TYPE:MEANING'
, DECODE(SIGN(TLGD.AMOUNT)
, -1
, ABS(TLGD.AMOUNT)
, NULL)
, DECODE(SIGN(TLGD.AMOUNT)
, 1
, TLGD.AMOUNT
, NULL)
, DECODE(SIGN(TLGD.ACCTD_AMOUNT)
, -1
, ABS(TLGD.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(TLGD.ACCTD_AMOUNT)
, 1
, TLGD.ACCTD_AMOUNT
, NULL)
, TLGD.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, '_DF:AR:RA_CUST_TRX_LINE_GL_DIST:TLGD'
, /* RESOLVED FK RESOLUTIONS */ CT.TRX_NUMBER
, CTL.LINE_NUMBER
, '_KF:SQLGL:GL#:GCC'
, AOU.NAME
, /* IDS */ TLGD.CUSTOMER_TRX_ID
, TLGD.CUSTOMER_TRX_LINE_ID
, TLGD.CODE_COMBINATION_ID
, TLGD.ORG_ID
, /* WHO COLUMNS */ TLGD.LAST_UPDATE_DATE
, TLGD.LAST_UPDATED_BY
, TLGD.CREATION_DATE
, TLGD.CREATED_BY
FROM AR_XLA_CTLGD_LINES_V TLGD
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS AOU
, XLA_AE_HEADERS HED
WHERE TLGD.ACCOUNT_CLASS = 'FREIGHT'
AND TLGD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID (+)
AND TLGD.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID (+)
AND TLGD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND TLGD.ORG_ID = AOU.ORGANIZATION_ID(+)
AND TLGD.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY