DBA Data[Home] [Help]

APPS.EAM_IMPORT_WORKORDERS dependencies on WIP_DISCRETE_JOBS

Line 123: SELECT asset_number INTO l_asset_serial_number FROM wip_discrete_jobs

119: l_wip_entity_id := l_eam_wo_rec.wip_entity_id;
120: l_eam_wo_rec.attribute15 := NULL; -- this att was made to import for diverting the flow from rossetta api, remove this after adding a new var in l_eam_wo_rec
121:
122: /*bug 8925120 l_eam_wo_rec.asset_number has instance number pushed from primavera, change it to (msn)serial_number*/
123: SELECT asset_number INTO l_asset_serial_number FROM wip_discrete_jobs
124: WHERE wip_entity_id= l_wip_entity_id AND organization_id=l_eam_wo_rec.organization_id;
125:
126: l_eam_wo_rec.asset_number := l_asset_serial_number;
127: /*bug 8925120 end */