DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 134: WIP_SHOP_FLOOR_STATUS_CODES wsfsc

130:
131:
132: select count(*) into x_valid_ez_complete
133: from WIP_SHOP_FLOOR_STATUSES wsfs, WIP_OPERATIONS wo,
134: WIP_SHOP_FLOOR_STATUS_CODES wsfsc
135: where wsfs.wip_entity_id = p_wip_entity_id
136: and wsfs.organization_id = p_org_id
137: and nvl (wsfs.line_id, -1) = nvl (p_line_id, -1)
138: and wo.wip_entity_id = wsfs.wip_entity_id