View: RA_CUST_TRX_LINE_V

Product:	GMF - Process Manufacturing Financials
Description:	Customer transaction line view
Implementation/DBA Data:	APPS.RA_CUST_TRX_LINE_V

View Text

SELECT RCTL.CUSTOMER_TRX_ID
, RCT.TRX_NUMBER
, NVL(GD.GL_DATE
, RCT.TRX_DATE)
, RCTT.TYPE
, SUOM.UM_CODE
, RCTL.QUANTITY_CREDITED
, RCTL.QUANTITY_INVOICED
, RCTL.INVENTORY_ITEM_ID
, RCTL.ATTRIBUTE8
, RCTL.ATTRIBUTE9
, RCTL.ATTRIBUTE10
, RCTL.ATTRIBUTE1
, RCTL.ATTRIBUTE5
, RCTL.ATTRIBUTE15
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL
, RA_CUSTOMER_TRX_ALL RCT
, RA_CUST_TRX_TYPES_ALL RCTT
, RA_CUST_TRX_LINE_GL_DIST_ALL GD
, SY_UOMS_MST SUOM
, MTL_UNITS_OF_MEASURE MUOM
WHERE RCTT.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
AND (RCTT.CUST_TRX_TYPE_ID
, RCTT.ORG_ID) = (SELECT CTTYP.CUST_TRX_TYPE_ID
, CTTYP.ORG_ID
FROM RA_CUST_TRX_TYPES_ALL CTTYP
WHERE CTTYP.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
AND ROWNUM = 1)
AND RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND UPPER(RCT.COMPLETE_FLAG) = 'Y'
AND SUOM.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE
AND MUOM.UOM_CODE = (SELECT NVL(RCTL.UOM_CODE
, MSI.PRIMARY_UOM_CODE)
FROM MTL_SYSTEM_ITEMS MSI
WHERE MSI.INVENTORY_ITEM_ID = RCTL.INVENTORY_ITEM_ID
AND ROWNUM = 1)
AND RCTL.LINE_TYPE = 'LINE'
AND RCTL.INVENTORY_ITEM_ID IS NOT NULL
AND RCT.CUSTOMER_TRX_ID = GD.CUSTOMER_TRX_ID
AND GD.ACCOUNT_CLASS = 'REC'
AND GD.LATEST_REC_FLAG = 'Y'

Columns