DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 1121: from wip_shop_floor_status_codes wsfsc,

1117: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1118: and upper(nvl(mti.flow_schedule, 'N')) = 'N'
1119: and operation_seq_num is not null
1120: and exists (select 'X'
1121: from wip_shop_floor_status_codes wsfsc,
1122: wip_shop_floor_statuses wsfs
1123: where wsfs.wip_entity_id = mti.transaction_source_id
1124: and wsfs.organization_id = mti.organization_id
1125: and nvl(wsfs.line_id, -1) = nvl(mti.repetitive_line_id, -1)

Line 1138: from wip_shop_floor_status_codes wsfsc,

1134: for i in 1..l_sfRecTbl.txnIntID.count loop
1135:
1136: select wsfs.shop_floor_status_code
1137: into l_sf_status
1138: from wip_shop_floor_status_codes wsfsc,
1139: wip_shop_floor_statuses wsfs
1140: where wsfs.wip_entity_id = l_sfRecTbl.txnSrcID(i)
1141: and wsfs.organization_id = l_sfRecTbl.orgID(i)
1142: and nvl(wsfs.line_id, -1) = nvl(l_sfRecTbl.lineID(i) , -1)