We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need RMA quantity for the query i have written

Question
15
Views
0
Comments

Content

Hi Gurus,

Please help me in getting RMA details for the below query along with the main query mentioned for original order below.

 

Version

20A

Code Snippet

SELECT to_char(DHA.ORDERED_DATE,'dd.mm.yyyy') "SALES ORDER CREATION DATE"
,DHA.STATUS_CODE "SALES ORDER HEADER STATUS"
,DLA.STATUS_CODE "SALES ORDER LINE STATUS"
,HP.PARTY_NAME "CUSTOMER NAME"
,HCA.ACCOUNT_NUMBER "CUSTOMER NUMBER"
,DHA.ORDER_TYPE_CODE "ORDER TYPE"
,ESIB.SALES_PRODUCT_TYPE "PRODUCT TYPE"
,ECT.CATEGORY_NAME "ITEM CATEGORY"
,EICT.ITEM_CLASS_NAME "ITEM CLASS"
,ESIB.ATTRIBUTE3 "PRODUCT ATTRIBUTE"
,ESIB.ATTRIBUTE2 "ITEM TYPE"
,ESIB.ATTRIBUTE4 "COLOR"
,ESIB.ATTRIBUTE5 "SIZE"
,ESIB.ITEM_NUMBER "ITEM NUMBER" 
,ESIT.DESCRIPTION "ITEM DESCRIPTION"
,NULL "PRICE LIST NAME"
,DLA.UNIT_SELLING_PRICE "UNIT PRICE"
,DLA.ORDERED_QTY "ORDER QTY"
,DFLA.SHIPPED_QTY "SHIP QTY"

,NULL "RMA QTY"
FROM DOO_HEADERS_ALL DHA
,DOO_LINES_ALL DLA
,DOO_FULFILL_LINES_ALL DFLA
,HZ_PARTIES HP
,HZ_CUST_ACCOUNTS HCA
,EGP_SYSTEM_ITEMS_B ESIB
,EGP_SYSTEM_ITEMS_TL ESIT
,INV_ORG_PARAMETERS IOP
,EGP_ITEM_CLASSES_B EICB
,EGP_ITEM_CLASSES_TL EICT
,EGP_CATEGORIES_B ECB
,EGP_CATEGORIES_TL ECT
,EGP_ITEM_CATEGORIES EIC
WHERE 1=1
AND DLA.HEADER_ID=DHA.HEADER_ID
AND HP.PARTY_ID = DHA.SOLD_TO_PARTY_ID
AND HP.PARTY_ID =HCA.PARTY_ID
AND DLA.INVENTORY_ITEM_ID = ESIB.INVENTORY_ITEM_ID
AND DLA.INVENTORY_ORGANIZATION_ID = ESIB.ORGANIZATION_ID
AND ESIB.INVENTORY_ITEM_ID = ESIT.INVENTORY_ITEM_ID 
AND ESIB.ORGANIZATION_ID = ESIT.ORGANIZATION_ID 
AND ESIT.LANGUAGE = USERENV('LANG') 
AND IOP.ORGANIZATION_ID = ESIB.ORGANIZATION_ID
AND ESIB.ITEM_CATALOG_GROUP_ID = EICB.ITEM_CLASS_ID
AND EICB.ITEM_CLASS_ID =EICT.ITEM_CLASS_ID
AND EICT.LANGUAGE = USERENV('LANG') 
AND DFLA.LINE_ID=DLA.LINE_ID
AND

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!