Please enable JavaScript.
Coggle requires JavaScript to display documents.
AMD TMP WIP Planning Automation (Aging and Fresh), FGS step ( 6020,6411…
AMD TMP WIP Planning Automation (Aging and Fresh)
Overall WIP
Get data from MES report to \pngjvatmp3fs\pngPDM\Planner_Automation\TMP_WIP_PLANING.xlsx
Mapping Master Product data for BU \pngjvatmp3fs\pngPDM\IE_Automation\Product_master_mapping.xlsx
Filter only < 100 days
Get Process_Spec - SMR if yes "isSMR"
FLAG FUSE check
check BOM if is PS after7604 the flag as "1"
Get all PN from WIP report and query BOM binlist database for all product chain
Result will be save to (detail PS and BOM) \pngjvatmp3fs\pngPDM\Planner_Automation\Master\TMP_BOM_OPN.xlsx
Process Result with Summary to only LIST ( PN , OPN )\pngjvatmp3fs\pngPDM\Planner_Automation\Master\TMP_BOM_OPN_Summary.xlsx
Thinking of insert to database ?
For future use -->
not required
Summary OPN with Lot count and Qty
FGS step ( 6020,6411,6410,6538)
\vpngfile66\cybfsboe\PNG\pngCrystalReports\FSODS_PROD\pwks0040all(no_dr).xls
FUM and Fresh
Python Script Process (PN_TMP_Bom_Validation.py)
Python Script Process (TMP_BOM_OPN_Summary.py)
Excel Automation (Stage 1) --> Stage 2 ( Database ) -