DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on WIP_SHOP_FLOOR_STATUSES

Line 1122: wip_shop_floor_statuses wsfs

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)
1126: and wsfs.operation_seq_num = mti.operation_seq_num

Line 1139: wip_shop_floor_statuses wsfs

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)
1143: and wsfs.operation_seq_num = l_sfRecTbl.opSeqNum(i)