DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 1113: from wip_shop_floor_status_codes wsfsc,

1109: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1110: and upper(nvl(mti.flow_schedule, 'N')) = 'N'
1111: and operation_seq_num is not null
1112: and exists (select 'X'
1113: from wip_shop_floor_status_codes wsfsc,
1114: wip_shop_floor_statuses wsfs
1115: where wsfs.wip_entity_id = mti.transaction_source_id
1116: and wsfs.organization_id = mti.organization_id
1117: and nvl(wsfs.line_id, -1) = nvl(mti.repetitive_line_id, -1)