Oracle Master: not loaded

SFG Production Planning Dashboard

Equipment Blocking Status

EQPT	Balance Qty	1st Schedule	Blocked Till	Days	Free Days	Overdue	Today's Alloc Cost
Assign EQPT in drill-down to see blocking status.

Balance Quantity by HOD

HOD	Open Lines	Balance Qty
Assign HOD in drill-down to see workload distribution.

Balance Quantity by Party

Party	Open Lines	Balance Qty	Max End Date	Overdue
No open party balances.

SFG BOM Requirements (Pivot) - click any row to drill down; Production Done = sum of per-line entries in drill-down; Balance = SFG Net Qty − Production Done

Unit SFG Level 3 SFG Level 4 Stages EQPT HOD Party Approve Status Commit Start Commit End Date From Date To Search Non-zero only Balance non-zero only

RM Requirements Summary

#	RM Item Name	UM	Req Qty	BOMs
Loading...

PORD-wise SFG Balance

PORD No	SFG Balance	Max End Date	Days Left
Loading...

TEAM MASTER - live from Google Sheet tab: TEAM MASTER_MANPOWER

Open Team Master page to load data.

Party-wise Net MC & Bal % to PO Issue

Party	BOMs	Net MC Qty	Bal to PO Issue	% (Bal / Net MC)
No data yet.

Production Progress (overall)

No data yet.

MC STATUS (Pivot) - live from Google Sheet tab: MC STATUS; click any row for child rows; Balance = Net MC Qty − Production Done

Search Balance status Min % Bal

Open MC Status page to load data.

BAL INSP AG OFFER - Item-wise: NET OFFER QTY, BALANCE INSPECTION QTY & % OF BALANCE | Source: BAL_INS_AG_OFF_BI_DUMP

Search Balance Status Min % Bal

# Item Code ↕	Item Name ↕	UM ↕	NET OFFER QTY ↕	BAL INSP QTY ↕	MC STOCK (KM) ↕	% OF BALANCE ↕	Offers ↕
Open BAL INSP AG OFFER page to load data.

Oracle DB: Checking... Secure route: python-oracledb → bind variables only — no raw SQL from browser

Saved Queries

Select a query to run

Force refresh

Login

User Control Panel

Add, edit, and remove users. Super Admin only.

View Access Filter

Configure data access

How it works: Pick one or more columns from the sheet and select which values the User is allowed to see. A row is shown only if it matches EVERY column (AND across columns, OR within each column). Empty = no data visible.

Reschedule Equipment

Reorder bookings using the up/down arrows. Dates auto-shift back-to-back starting from the earliest original start date. Click Apply to save.

Read-only view. Only Admin / Super Admin can edit dates and apply schedule changes.

Reason for reschedule * (mandatory â€" applies to both date increase and interchange)

Allocation date Team Shift * 0 selected

Pick a date and team, then click Load team members.

Add member from another team (only members FREE on this date are listed)

Laser Power

SFG BOM Requirements - Static GitHub Pages Refresh â†» Hard Refresh SFG Dashboard Team Master MC Status BAL INSP AG OFFER 📃 Query Panel Not logged in Login User Panel Logout

SFG Production Planning Dashboard

Equipment Blocking Status

Balance Quantity by HOD

Balance Quantity by Party

SFG BOM Requirements (Pivot) - click any row to drill down; Production Done = sum of per-line entries in drill-down; Balance = SFG Net Qty − Production Done

RM Requirements Summary

PORD-wise SFG Balance

TEAM MASTER - live from Google Sheet tab: TEAM MASTER_MANPOWER

Party-wise Net MC & Bal % to PO Issue

Production Progress (overall)

MC STATUS (Pivot) - live from Google Sheet tab: MC STATUS; click any row for child rows; Balance = Net MC Qty − Production Done

BAL INSP AG OFFER - Item-wise: NET OFFER QTY, BALANCE INSPECTION QTY & % OF BALANCE | Source: BAL_INS_AG_OFF_BI_DUMP

Saved Queries + Add Query

Select a query to run

Item Details

Login

MC Status Details

User Control Panel

View Access Filter

Drill Down

Reschedule Equipment

Production Order

Manpower Allocation

Allocation Detail

SFG BOM Requirements - Static GitHub Pages Not logged in

Saved Queries