Bugzilla – Attachment 3305 Details for
Bug 10235
Migrate reports of Production Order
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
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:
output, Layout and SQL
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 > ) >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 10235
: 3305 |
3306