psi_mmobile

Untitled

Apr 10th, 2026
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. select ccp.*
  2. from mfc_mobile_worker mfcmw, person p, oc_poi ocp, cal_closing_period ccp, work_code wc, oc_calendar occ, operation_center oc
  3. where mfcmw.erp_id = p.person_id
  4. and p.hiring_p_oc_poi_id = ocp.poi_id
  5. and ocp.oc_calendar_id = ccp.oc_calendar_id
  6. and ccp.oc_calendar_id = occ.oc_calendar_id
  7. and occ.operation_center_id = oc.operation_center_id
  8. and ccp.work_code_id = wc.work_code_id
  9. and p.person_id = 537437;
Advertisement
Add Comment
Please, Sign In to add comment