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 2946: FROM SYS.DUAL;

2942:
2943: BEGIN
2944: SELECT MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
2945: INTO l_session_id
2946: FROM SYS.DUAL;
2947: EXCEPTION
2948: WHEN no_data_found THEN
2949: IF G_TRACE_ON = 1 THEN
2950: print_debug('Exception: MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL is not defined'

Line 3220: l_dual_uom_control NUMBER ;

3216: l_location_id NUMBER;
3217: l_asset_flag NUMBER :=1 ; -- Bug 4178417
3218: l_exp_acct NUMBER ; -- Bug 4178417
3219: l_charge_acct NUMBER ; -- Bug 4178417
3220: l_dual_uom_control NUMBER ;
3221: l_secondary_qty NUMBER ;
3222: l_secondary_uom VARCHAR2(3) ;
3223: BEGIN
3224: SAVEPOINT sp_do_restock;

Line 3528: SELECT dual_uom_control,

3524: END IF;
3525: /* --------INVCONV changes------------------------------ */
3526:
3527: IF p_process_enabled = 'Y' THEN
3528: SELECT dual_uom_control,
3529: secondary_uom_code
3530: INTO l_dual_uom_control,
3531: l_secondary_uom
3532: FROM mtl_system_items

Line 3530: INTO l_dual_uom_control,

3526:
3527: IF p_process_enabled = 'Y' THEN
3528: SELECT dual_uom_control,
3529: secondary_uom_code
3530: INTO l_dual_uom_control,
3531: l_secondary_uom
3532: FROM mtl_system_items
3533: WHERE organization_id = p_organization_id
3534: AND inventory_item_id = p_item_id;

Line 3536: IF l_dual_uom_control > 1 THEN

3532: FROM mtl_system_items
3533: WHERE organization_id = p_organization_id
3534: AND inventory_item_id = p_item_id;
3535:
3536: IF l_dual_uom_control > 1 THEN
3537: l_secondary_qty := inv_convert.inv_um_convert
3538: (item_id => p_item_id
3539: ,precision => 5
3540: ,from_quantity => p_qty

Line 4167: from dual;

4163: l_scheduling_method := 2;
4164: END IF;
4165: select wsm_lot_sm_ifc_header_s.nextval
4166: into l_header_id
4167: from dual;
4168:
4169: l_mode_flag := 1;
4170:
4171: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval

Line 4173: from dual;

4169: l_mode_flag := 1;
4170:
4171: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4172: INTO l_job_name
4173: from dual;
4174:
4175: print_debug('OSFM Job Name '||l_job_name
4176: , 're_wip', 9);
4177:

Line 4214: FROM dual

4210: ELSIF (l_cfm_flag = 3) AND (wsmpvers.get_osfm_release_version > '110509')
4211: THEN
4212: BEGIN
4213: SELECT 'Y' INTO l_is_lot_control
4214: FROM dual
4215: WHERE exists
4216: (SELECT 1 FROM mtl_system_items
4217: WHERE organization_id = p_organization_id
4218: AND inventory_item_id = p_item_id

Line 4234: FROM SYS.DUAL;

4230:
4231: BEGIN
4232: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
4233: INTO l_osfm_batch_id
4234: FROM SYS.DUAL;
4235: EXCEPTION
4236: WHEN no_data_found THEN
4237: IF G_TRACE_ON = 1 THEN
4238: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'