VIEW: APPS.RA_CUST_TRX_LINE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'