DBA Data[Home] [Help]

APPS.WIP_DIAG_DATA_COLL dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 5454: FROM wip_shop_floor_status_codes wsfsc ,

5450: SELECT wsfsc.shop_floor_status_code ,
5451: wsfsc.status_move_flag ,
5452: ml.meaning ,
5453: wsfsc.status_move_flag status_move_flag_code
5454: FROM wip_shop_floor_status_codes wsfsc ,
5455: mfg_lookups ml
5456: WHERE ml.lookup_type = 'SYS_YES_NO'
5457: AND ml.lookup_code = wsfsc.status_move_flag
5458: AND organization_id = p_org_id ;