VIEW: APPS.ARBV_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' , /* 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, XLA_AE_HEADERS HED WHERE TLGD.ACCOUNT_CLASS = 'FREIGHT' 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'
, /* 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
, XLA_AE_HEADERS HED
WHERE TLGD.ACCOUNT_CLASS = 'FREIGHT'
AND TLGD.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY