APPS.INV_MINMAX_PVT dependencies on DUAL

Line 686: FROM dual;

682: IF p_level = 1 THEN --only for org level; default is 'N'
683:
684: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')
685: INTO l_vmi_enabled
686: FROM dual;
687: END IF;
688:
689: EXCEPTION
690: WHEN OTHERS THEN

Line 2956: FROM SYS.DUAL;

2952:
2953: BEGIN
2954: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
2955: INTO l_session_id
2956: FROM SYS.DUAL;
2957: EXCEPTION
2958: WHEN no_data_found THEN
2959: IF G_TRACE_ON = 1 THEN
2960: print_debug('Exception: MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL is not defined'

Line 3230: l_dual_uom_control NUMBER ;

3226: l_location_id NUMBER;
3227: l_asset_flag NUMBER :=1 ; -- Bug 4178417
3228: l_exp_acct NUMBER ; -- Bug 4178417
3229: l_charge_acct NUMBER ; -- Bug 4178417
3230: l_dual_uom_control NUMBER ;
3231: l_secondary_qty NUMBER ;
3232: l_secondary_uom VARCHAR2(3) ;
3233: BEGIN
3234: SAVEPOINT sp_do_restock;

Line 3536: /* 4004567 Instead of checking whether the item is dual uom controlled by checking if the item is defined to the org which is process enabled or not. Made change to check if the item has secondary_uom */

3532: , 9);
3533: END IF;
3534: END IF;
3535: /* --------INVCONV changes------------------------------ */
3536: /* 4004567 Instead of checking whether the item is dual uom controlled by checking if the item is defined to the org which is process enabled or not. Made change to check if the item has secondary_uom */
3537:
3538: IF inv_cache.set_item_rec(p_organization_id =>p_organization_id,p_item_id => p_item_id) THEN
3539: l_secondary_uom := inv_cache.item_rec.secondary_uom_code;
3540: END IF;

Line 4174: from dual;

4170: l_scheduling_method := 2;
4171: END IF;
4172: select wsm_lot_sm_ifc_header_s.nextval
4173: into l_header_id
4174: from dual;
4175:
4176: l_mode_flag := 1;
4177:
4178: /*Bug 15837698 Moved this part just before inserting into wsm_lot_job_interface*/

Line 4181: from dual;

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
4184: , 're_wip', 9);*/
4185:

Line 4222: FROM dual

4218: ELSIF (l_cfm_flag = 3) AND (wsmpvers.get_osfm_release_version > '110509')
4219: THEN
4220: BEGIN
4221: SELECT 'Y' INTO l_is_lot_control
4222: FROM dual
4223: WHERE exists
4224: (SELECT 1 FROM mtl_system_items
4225: WHERE organization_id = p_organization_id
4226: AND inventory_item_id = p_item_id

Line 4242: FROM SYS.DUAL;

4238:
4239: BEGIN
4240: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
4241: INTO l_osfm_batch_id
4242: FROM SYS.DUAL;
4243: EXCEPTION
4244: WHEN no_data_found THEN
4245: IF G_TRACE_ON = 1 THEN
4246: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'

Line 4269: from dual;

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);
4272: /*End of Bug 15837698*/
4273: