APPS.INV_COST_GROUP_UPDATE dependencies on DUAL

Line 260: SELECT 1 INTO l_onhand FROM dual

256: BEGIN
257: BEGIN
258: IF p_lpn_id IS NULL THEN
259: IF p_serial_number IS NULL THEN
260: SELECT 1 INTO l_onhand FROM dual
261: WHERE exists
262: (SELECT organization_id
263: FROM mtl_onhand_quantities_detail moq
264: WHERE (moq.lot_number = p_lot_number

Line 275: SELECT 1 INTO l_onhand FROM dual

271: AND moq.organization_id = p_organization_id
272: AND Nvl(moq.containerized_flag, 2) = 2); -- Loose Items only
273:
274: ELSE
275: SELECT 1 INTO l_onhand FROM dual
276: WHERE exists
277: (SELECT current_organization_id
278: FROM mtl_serial_numbers msn
279: WHERE (msn.lot_number = p_lot_number

Line 293: SELECT 1 INTO l_onhand FROM dual

289: AND msn.current_organization_id = p_organization_id);
290: END IF;
291: ELSE
292: IF p_serial_number IS NULL THEN
293: SELECT 1 INTO l_onhand FROM dual
294: WHERE exists
295: (SELECT wlpn.organization_id
296: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
297: WHERE (wlc.lot_number = p_lot_number

Line 309: SELECT 1 INTO l_onhand FROM dual

305: AND wlc.parent_lpn_id = wlpn.lpn_id
306: AND wlc.organization_id = p_organization_id
307: AND wlc.parent_lpn_id = p_lpn_id);
308: ELSE
309: SELECT 1 INTO l_onhand FROM dual
310: WHERE exists
311: (SELECT current_organization_id
312: FROM mtl_serial_numbers msn
313: WHERE (msn.lot_number = p_lot_number

Line 349: SELECT 'Y' INTO l_valid FROM dual

345: BEGIN
346: l_valid := 'N';
347:
348: BEGIN
349: SELECT 'Y' INTO l_valid FROM dual
350: WHERE
351: EXISTS
352: (SELECT ccgA.cost_group_id FROM
353: cst_cost_group_accounts CCGA

Line 2443: FROM dual;

2439: ELSE
2440: -- otherwise generate a new_transaction_temp_id
2441: SELECT mtl_material_transactions_s.NEXTVAL
2442: INTO l_transaction_temp_id
2443: FROM dual;
2444: l_cg_quantity_table(l_cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
2445: l_cg_quantity_table(l_cost_group_id).update_mmtt := FALSE;
2446: END IF;
2447: l_cg_quantity_table(l_cost_group_id).primary_quantity := Abs(rec_mtlt.primary_quantity);

Line 2926: FROM dual;

2922: ELSE
2923: -- otherwise generate a new_transaction_temp_id
2924: SELECT mtl_material_transactions_s.NEXTVAL
2925: INTO l_transaction_temp_id
2926: FROM dual;
2927: IF (l_debug = 1) THEN
2928: print_debug('l_transaction_temp_id: ' || l_transaction_temp_id);
2929: END IF;
2930: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := l_transaction_temp_id;

Line 3484: FROM dual;

3480: --Bug 3390284
3481: ELSE
3482: SELECT mtl_material_transactions_s.NEXTVAL
3483: INTO l_transaction_temp_id
3484: FROM dual;
3485:
3486: l_serial_table(l_sti).new_serial_transaction_temp_id:= l_transaction_temp_id;
3487:
3488: --Bug 3390284

Line 3536: FROM dual;

3532: l_serial_table(l_sti).quantity := 1;
3533:
3534: SELECT mtl_material_transactions_s.NEXTVAL
3535: INTO l_transaction_temp_id
3536: FROM dual;
3537:
3538: --3390284
3539: IF lot_cg_qty_table.exists(rec_msn.cost_group_id) then
3540: lot_cg_qty_table(rec_msn.cost_group_id).quantity :=

Line 3593: FROM dual;

3589: ELSE
3590: -- otherwise generate a new_transaction_temp_id
3591: SELECT mtl_material_transactions_s.NEXTVAL
3592: INTO l_transaction_temp_id
3593: FROM dual;
3594: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
3595: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := FALSE;
3596: END IF;
3597: l_cg_quantity_table(rec_msn.cost_group_id).quantity := 1;