VIEW: APPS.SO_LINES_RETURN_LINES_V

Source

View Text - Preformatted

SELECT /*+ INDEX(SH SO_HEADERS_U1) INDEX(SL SO_LINES_N24) */ SL.LINE_ID LINE_ID , SL.HEADER_ID HEADER_ID , SL.LINE_NUMBER LINE_NUMBER , UOM.UOM_CODE UOM_CODE , NVL(SL.ORDERED_QUANTITY,0)-NVL(SL.CANCELLED_QUANTITY,0) OPEN_QUANTITY , SL.CANCELLED_QUANTITY CANCELLED_QUANTITY , SL.SELLING_PRICE SELLING_PRICE , AL.MEANING RETURN_REASON , RCT.TRX_NUMBER CREDIT_TO_INVOICE , OE_QUERY.ACCEPTED_QTY(SL.LINE_ID) ACCEPTED_QUANTITY , SH.ORDER_NUMBER , OE_QUERY.ORDER_TYPE(SH.ORDER_TYPE_ID) ORDER_TYPE , SH.CURRENCY_CODE , SL.RETURN_REFERENCE_TYPE_CODE , SL.RETURN_REFERENCE_ID , SL.CREATION_DATE , SL.CREATED_BY , SL.LAST_UPDATE_DATE , SL.LAST_UPDATED_BY , SL.LAST_UPDATE_LOGIN , SL.ROWID ROW_ID , SL.DATE_REQUESTED_CURRENT , 0 DUMMY_ID FROM SO_LINES SL, MTL_UNITS_OF_MEASURE UOM, AR_LOOKUPS AL , RA_CUSTOMER_TRX RCT, RA_CUSTOMER_TRX_LINES RCTL , SO_HEADERS SH WHERE UOM.UOM_CODE = NVL( SL.UNIT_CODE, 'EA' ) AND AL.LOOKUP_TYPE(+)='CREDIT_MEMO_REASON' AND AL.LOOKUP_CODE(+)=NVL(SL.TRANSACTION_REASON_CODE,'RETURN') AND RCT.CUSTOMER_TRX_ID(+) = RCTL.CUSTOMER_TRX_ID AND RCTL.CUSTOMER_TRX_LINE_ID(+) = SL.CREDIT_INVOICE_LINE_ID AND SH.HEADER_ID = SL.HEADER_ID

View Text - HTML Formatted

SELECT /*+ INDEX(SH SO_HEADERS_U1) INDEX(SL SO_LINES_N24) */ SL.LINE_ID LINE_ID
, SL.HEADER_ID HEADER_ID
, SL.LINE_NUMBER LINE_NUMBER
, UOM.UOM_CODE UOM_CODE
, NVL(SL.ORDERED_QUANTITY
, 0)-NVL(SL.CANCELLED_QUANTITY
, 0) OPEN_QUANTITY
, SL.CANCELLED_QUANTITY CANCELLED_QUANTITY
, SL.SELLING_PRICE SELLING_PRICE
, AL.MEANING RETURN_REASON
, RCT.TRX_NUMBER CREDIT_TO_INVOICE
, OE_QUERY.ACCEPTED_QTY(SL.LINE_ID) ACCEPTED_QUANTITY
, SH.ORDER_NUMBER
, OE_QUERY.ORDER_TYPE(SH.ORDER_TYPE_ID) ORDER_TYPE
, SH.CURRENCY_CODE
, SL.RETURN_REFERENCE_TYPE_CODE
, SL.RETURN_REFERENCE_ID
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, SL.LAST_UPDATE_LOGIN
, SL.ROWID ROW_ID
, SL.DATE_REQUESTED_CURRENT
, 0 DUMMY_ID
FROM SO_LINES SL
, MTL_UNITS_OF_MEASURE UOM
, AR_LOOKUPS AL
, RA_CUSTOMER_TRX RCT
, RA_CUSTOMER_TRX_LINES RCTL
, SO_HEADERS SH
WHERE UOM.UOM_CODE = NVL( SL.UNIT_CODE
, 'EA' )
AND AL.LOOKUP_TYPE(+)='CREDIT_MEMO_REASON'
AND AL.LOOKUP_CODE(+)=NVL(SL.TRANSACTION_REASON_CODE
, 'RETURN')
AND RCT.CUSTOMER_TRX_ID(+) = RCTL.CUSTOMER_TRX_ID
AND RCTL.CUSTOMER_TRX_LINE_ID(+) = SL.CREDIT_INVOICE_LINE_ID
AND SH.HEADER_ID = SL.HEADER_ID