Attachment 3306 Details for Bug 10235 – Production Order Cons Rep SQL

Production Order Cons Rep SQL

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

(hide)

Description:

Filename:

MIME Type:

Creator: PNSrivastava

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

Size: 2.17 KB

patch

obsolete

>SELECT    PKG_VOUCHERS.GET_VOUCHER_STRING ("PO"."COMPANY", "PO"."VOUCHER_TYPE", "PO"."VOUCHER_SERIES", "PO"."VOUCHER_NO") as po_no,
>            "PO"."VOUCHER_DATE",
>            "PO"."ENTRY_NO",   
>            "IW_BOM"."ITEM_CODE",
>            "VW_ALL_FG_NFG_ITEMS"."ITEM_NAME",
>            "IW_BOM"."STOCK_TYPE",
>            "POI"."REQUIRED_QTY", 
>            
>            "IW_BOM_PARTS"."PART_CODE",
>            "X"."ITEM_NAME",           
>            "IW_BOM_PARTS"."STOCK_TYPE",
>            "VW_ALL_FG_NFG_ITEMS"."IUOM_CODE",
>            "X"."IUOM_CODE",
>			"IW_BOM_PARTS"."QUANTITY",
>            "POI"."REQUIRED_QTY" * "IW_BOM_PARTS"."QUANTITY" as qty_consumed,
>            "PO"."COMPANY",
>            "IW_BOM_SUB_PARTS"."SUB_PART_CODE",
>            "Y"."ITEM_NAME",
>            "IW_BOM_SUB_PARTS"."STOCK_TYPE", 
>            "IW_BOM_SUB_PARTS"."MAX_QUANTITY",
>            ("POI"."REQUIRED_QTY" * "IW_BOM_PARTS"."QUANTITY") * "IW_BOM_SUB_PARTS"."MAX_QUANTITY" as sub_qty_consumed,
>            "Y"."IUOM_CODE"
>
>
>FROM 		 "IW_PRODUCTION_ORDERS" PO
>            ,"IW_PRODUCTION_ORDER_ITEMS" POI
>            ,"IW_BOM"
>            ,"IW_BOM_PARTS"
>            ,"IW_BOM_SUB_PARTS"
>            ,"VW_ALL_FG_NFG_ITEMS"
>            ,"VW_ALL_FG_NFG_ITEMS" X
>            ,"VW_ALL_FG_NFG_ITEMS" Y
>
>         
>WHERE		    "PO"."PRDORDR_RECID" = "POI"."PRDORDR_RECID" AND
>                "POI"."BOM_RECID" = "IW_BOM"."BOM_RECID" AND
>                "IW_BOM"."ITEM_CODE" = "VW_ALL_FG_NFG_ITEMS"."ITEM_CODE" AND
>                "IW_BOM"."STOCK_TYPE" = "VW_ALL_FG_NFG_ITEMS"."STOCK_TYPE" AND
>				"IW_BOM"."BOM_RECID" = "IW_BOM_PARTS"."BOM_RECID" (+)AND
>                "IW_BOM_PARTS"."BOM_PARTS_RECID" = "IW_BOM_SUB_PARTS"."BOM_PARTS_RECID" (+)AND
>                "IW_BOM_PARTS"."PART_CODE" = "X"."ITEM_CODE" (+) AND
>                "IW_BOM_PARTS"."STOCK_TYPE" = "X"."STOCK_TYPE" (+) AND     
>                "IW_BOM_SUB_PARTS"."SUB_PART_CODE" = "Y"."ITEM_CODE" (+) AND
>                "IW_BOM_SUB_PARTS"."STOCK_TYPE" = "Y"."STOCK_TYPE" (+) AND
>				("IW_BOM"."ITEM_CODE" BETWEEN :arg_from_item_code AND :arg_to_item_code) AND
>				("PO"."VOUCHER_DATE" BETWEEN :arg_from_date and :arg_upto_date)
>

Actions: View

Attachments on bug 10235: 3305 | 3306