Attachment 3305 Details for Bug 10235 – output, Layout and SQL

output, Layout and SQL

Production Order Report - SQL.txt (text/plain), 1.24 KB, created by PNSrivastava on 2023-02-20 10:05:02 IST

(hide)

Description:

Filename:

MIME Type:

Creator: PNSrivastava

Created: 2023-02-20 10:05:02 IST

Size: 1.24 KB

patch

obsolete

>SELECT    P.COMPANY
>             ,P.VOUCHER_TYPE
>         	,P.VOUCHER_SERIES
>         	,P.VOUCHER_NO
>         	,P.VOUCHER_DATE
>         	,P.STATUS
>         	,P.REMARKS
>        		,B.ITEM_CODE
>         	,B.STOCK_TYPE
>         	,B.BOM_EDITION
>         	,B.REVISION_NO
>         	,B.DESCRIPTION
>         	,I.REQUIRED_QTY
>         	,I.ACTUAL_QTY
>         	,I.DUE_START_DATE
>         	,I.DUE_END_DATE
>         	,I.ACTUAL_START_DATE
>         	,I.ACTUAL_END_DATE
>         	,ST.STOCK_NAME
>         	,ST.IUOM_CODE
>         	,PO.DESCRIPTION
>    FROM     IW_PRODUCTION_ORDERS P
>                 ,IW_PRODUCTION_ORDER_ITEMS I
>                 ,IW_BOM B
>         	    ,IW_ALL_STOCK_TYPES ST
>                  ,POPLIST_TABLEDAT PO
>   WHERE     P.PRDORDR_RECID     = I.PRDORDR_RECID
>   AND         I.BOM_RECID         = B.BOM_RECID
>   AND      B.ITEM_CODE         = ST.ITEM_CODE
>   AND      B.STOCK_TYPE         = ST.STOCK_TYPE
>   AND      PO.POPLIST_ID         = 'SOSTATUS'
>   AND      P.STATUS           = PO.DETAIL_CODE
>   AND     P.COMPANY = :ARG_COMPANY
>   AND    ((P.VOUCHER_TYPE  = :ARG_VOUCHER_TYPE AND P.VOUCHER_SERIES  = :ARG_VOUCHER_SERIES AND P.VOUCHER_NO = :ARG_VOUCHER_NUMBER)  
>				or     
>				P.ENTRY_NO    = :ARG_ENTRY_NO
>			)
>

Actions: View

Attachments on bug 10235: 3305 | 3306