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 2431: FROM dual;

2427: ELSE
2428: -- otherwise generate a new_transaction_temp_id
2429: SELECT mtl_material_transactions_s.NEXTVAL
2430: INTO l_transaction_temp_id
2431: FROM dual;
2432: l_cg_quantity_table(l_cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
2433: l_cg_quantity_table(l_cost_group_id).update_mmtt := FALSE;
2434: END IF;
2435: l_cg_quantity_table(l_cost_group_id).primary_quantity := Abs(rec_mtlt.primary_quantity);

Line 2914: FROM dual;

2910: ELSE
2911: -- otherwise generate a new_transaction_temp_id
2912: SELECT mtl_material_transactions_s.NEXTVAL
2913: INTO l_transaction_temp_id
2914: FROM dual;
2915: IF (l_debug = 1) THEN
2916: print_debug('l_transaction_temp_id: ' || l_transaction_temp_id);
2917: END IF;
2918: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := l_transaction_temp_id;

Line 3472: FROM dual;

3468: --Bug 3390284
3469: ELSE
3470: SELECT mtl_material_transactions_s.NEXTVAL
3471: INTO l_transaction_temp_id
3472: FROM dual;
3473:
3474: l_serial_table(l_sti).new_serial_transaction_temp_id:= l_transaction_temp_id;
3475:
3476: --Bug 3390284

Line 3524: FROM dual;

3520: l_serial_table(l_sti).quantity := 1;
3521:
3522: SELECT mtl_material_transactions_s.NEXTVAL
3523: INTO l_transaction_temp_id
3524: FROM dual;
3525:
3526: --3390284
3527: IF lot_cg_qty_table.exists(rec_msn.cost_group_id) then
3528: lot_cg_qty_table(rec_msn.cost_group_id).quantity :=

Line 3581: FROM dual;

3577: ELSE
3578: -- otherwise generate a new_transaction_temp_id
3579: SELECT mtl_material_transactions_s.NEXTVAL
3580: INTO l_transaction_temp_id
3581: FROM dual;
3582: l_cg_quantity_table(rec_msn.cost_group_id).new_transaction_temp_id := l_transaction_temp_id;
3583: l_cg_quantity_table(rec_msn.cost_group_id).update_mmtt := FALSE;
3584: END IF;
3585: l_cg_quantity_table(rec_msn.cost_group_id).quantity := 1;