DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_REPETITIVE_ITEMS

Line 64: and not exists (select 'X' from WIP_REPETITIVE_ITEMS WRI

60: where DJ.WIP_ENTITY_ID = p_wip_entity_id
61: and DJ.ORGANIZATION_ID = p_org_id
62: and DJ.COMPLETION_SUBINVENTORY IS NOT NULL))
63: or (we.entity_type = WIP_CONSTANTS.REPETITIVE)
64: and not exists (select 'X' from WIP_REPETITIVE_ITEMS WRI
65: where WRI.WIP_ENTITY_ID = p_wip_entity_id
66: and WRI.ORGANIZATION_ID = p_org_id
67: and WRI.LINE_ID = p_line_id
68: and WRI.COMPLETION_SUBINVENTORY IS NOT NULL));