DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on WIP_JOB_NUMBER_S

Line 4179: /* select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval

4175:
4176: l_mode_flag := 1;
4177:
4178: /*Bug 15837698 Moved this part just before inserting into wsm_lot_job_interface*/
4179: /* select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4180: INTO l_job_name
4181: from dual;
4182:
4183: print_debug('OSFM Job Name '||l_job_name

Line 4265: /*Bug 15837698 If it is a lot controlled item, only then use wip_job_number_s.nextval

4261:
4262:
4263: IF l_is_lot_control = 'Y' THEN
4264:
4265: /*Bug 15837698 If it is a lot controlled item, only then use wip_job_number_s.nextval
4266: before inserting data into WSM_LOT_JOB_INTERFACE */
4267: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4268: INTO l_job_name
4269: from dual;

Line 4267: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval

4263: IF l_is_lot_control = 'Y' THEN
4264:
4265: /*Bug 15837698 If it is a lot controlled item, only then use wip_job_number_s.nextval
4266: before inserting data into WSM_LOT_JOB_INTERFACE */
4267: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4268: INTO l_job_name
4269: from dual;
4270:
4271: print_debug('OSFM Job Name '||l_job_name , 're_wip', 9);