[Home] [Help]
275:
276: BEGIN
277: SELECT '1'
278: INTO l_dummy
279: FROM dual
280: WHERE exists (SELECT '1'
281: FROM mtl_txn_request_lines mtrl
282: WHERE mtrl.lpn_id = p_lpn_id
283: AND mtrl.organization_id = p_org_id
307: /*Bug8662279. Performance fix. Added the following
308: 1)Enabled cahche for one LPN_ID
309: 2)Moved WLPN query to form clause by adding org_id and context restrictions
310: 3)Eliminated need for extra WLPN
311: 4)Removed reference to DUAL and used ROWNUM<2
312: */
313: IF (p_lpn_id = g_mixed_expense_lpn_id ) THEN
314: RETURN g_mixed_expense_result;
315: ELSE
2900: END IF;
2901:
2902: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
2903: INTO l_lpn_grp_id
2904: FROM DUAL;
2905:
2906: UPDATE rcv_transactions_interface
2907: SET lpn_group_id = l_lpn_grp_id
2908: WHERE interface_transaction_id = l_lpn_grp_null.interface_transaction_id;
2983: END IF;
2984:
2985: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
2986: INTO l_lpn_grp_id
2987: FROM DUAL;
2988:
2989: UPDATE rcv_transactions_interface
2990: SET lpn_group_id = l_lpn_grp_id
2991: -- don't use shipment_num see update above ****
5094: --been validated by the ui already}}
5095: BEGIN
5096: SELECT 1
5097: INTO l_loaded
5098: FROM dual
5099: WHERE exists
5100: (SELECT 1
5101: FROM wms_dispatched_tasks wdt
5102: , mtl_material_transactions_temp mmtt
5500:
5501: BEGIN
5502: SELECT 1
5503: INTO l_loaded
5504: FROM dual
5505: WHERE exists
5506: (SELECT 1
5507: FROM wms_dispatched_tasks wdt
5508: , mtl_material_transactions_temp mmtt
7331:
7332: BEGIN
7333: SELECT 1
7334: INTO l_loaded
7335: FROM dual
7336: WHERE exists
7337: (SELECT 1
7338: FROM wms_dispatched_tasks wdt
7339: , mtl_material_transactions_temp mmtt
10988: l_progress := 'WMSINB-15850';
10989:
10990: SELECT rcv_transactions_interface_s.NEXTVAL
10991: INTO l_interface_transaction_id
10992: FROM DUAL;
10993:
10994: l_progress := 'WMSINB-15856';
10995:
10996: l_user_id := fnd_global.user_id;
11506:
11507: if l_lot_interface_id is null then
11508: SELECT mtl_material_transactions_s.NEXTVAL
11509: INTO l_lot_Interface_Id
11510: FROM DUAL;
11511: End if;
11512:
11513: l_serial_interface_id := null;
11514:
11524: -- Generate the serial interface id here
11525: if l_serial_interface_id is null then
11526: SELECT mtl_material_transactions_s.NEXTVAL
11527: INTO l_serial_Interface_Id
11528: FROM DUAL;
11529: End if;
11530:
11531: insert_msni(p_product_transaction_id => l_interface_transaction_id,
11532: p_product_code => 'RCV',
11587: -- Generate the serial interface id here
11588: if l_serial_interface_id is null then
11589: SELECT mtl_material_transactions_s.NEXTVAL
11590: INTO l_serial_Interface_Id
11591: FROM DUAL;
11592: End if;
11593:
11594: insert_msni(p_product_transaction_id => l_interface_transaction_id,
11595: p_product_code => 'RCV',
12028: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
12029: IF l_lot_interface_id IS NULL THEN
12030: SELECT mtl_material_transactions_s.NEXTVAL
12031: INTO l_lot_interface_id
12032: FROM DUAL;
12033: END IF;
12034:
12035: IF (l_mol_mmtt_ctnt_tb(i).txn_uom_code <> l_prim_uom_code) THEN
12036: l_prim_qty_to_insert := inv_rcv_cache.convert_qty(l_rs_tb(l_rs_index).inventory_item_id
12182: FOR j IN 1..l_rti_serial_tb(l_rti_index).COUNT LOOP
12183: IF l_serial_interface_id IS NULL THEN
12184: SELECT mtl_material_transactions_s.NEXTVAL
12185: INTO l_serial_Interface_Id
12186: FROM DUAL;
12187: END IF;
12188:
12189: IF (l_debug = 1) THEN
12190: print_debug('Inserting MSNI for serial: '||l_rti_serial_tb(l_rti_index)(j),4);
12212: IF (l_mol_mmtt_ctnt_tb(i).lot_number IS NOT NULL) THEN
12213: IF l_lot_interface_id IS NULL THEN
12214: SELECT mtl_material_transactions_s.NEXTVAL
12215: INTO l_lot_interface_id
12216: FROM DUAL;
12217: END IF;
12218:
12219: IF (l_debug = 1) THEN
12220: print_debug('Inserting MTLI for lot: '||l_mol_mmtt_ctnt_tb(i).lot_number||
14347: IF (Nvl(g_lpn_group_id,-999) <> p_lpn_group_id) THEN
14348: g_lpn_group_id := p_lpn_group_id;
14349: SELECT wms_epc_s2.NEXTVAL
14350: INTO g_epc_group_id
14351: FROM dual;
14352: END IF;
14353:
14354: IF (l_debug = 1) THEN
14355: print_debug('Calling populate_outside_epc',4);
17770: IF (l_mtli_rec.serial_transaction_temp_id IS NOT NULL)
17771: THEN
17772: SELECT mtl_material_transactions_s.NEXTVAL
17773: INTO l_new_serial_txn_temp_id
17774: FROM DUAL;
17775: ELSE
17776: l_new_serial_txn_temp_id := NULL;
17777: END IF;
17778:
19360: IF (l_lot_control_code = 1) THEN
19361: BEGIN
19362: SELECT '1'
19363: INTO l_dummy
19364: FROM dual
19365: WHERE exists (SELECT 1
19366: FROM mtl_transaction_lots_temp
19367: WHERE product_code = 'RCV'
19368: AND product_transaction_id = l_rti_id);
19416: IF (l_serial_number_control_code = 1 and l_serial_tagged <> 2) THEN
19417: BEGIN
19418: SELECT '1'
19419: INTO l_dummy
19420: FROM dual
19421: WHERE exists (SELECT 1
19422: FROM mtl_serial_numbers_temp
19423: WHERE product_code = 'RCV'
19424: AND product_transaction_id = l_rti_id);
19774: BEGIN
19775:
19776: SELECT '1'
19777: INTO l_dummy
19778: FROM dual
19779: WHERE EXISTS (SELECT 'comingling exists'
19780: from mtl_onhand_quantities_detail moqd,
19781: rcv_transactions_interface rti
19782: WHERE moqd.organization_id = rti.to_organization_id
21141: l_dummy := '0';
21142: BEGIN
21143: SELECT '1'
21144: INTO l_dummy
21145: FROM dual
21146: WHERE exists (SELECT '1'
21147: FROM mtl_serial_numbers
21148: WHERE inventory_item_id = l_item_id
21149: AND current_organization_id = l_org_id
22250: l_dummy := '0';
22251: BEGIN
22252: SELECT '1'
22253: INTO l_dummy
22254: FROM dual
22255: WHERE exists (SELECT '1'
22256: FROM mtl_serial_numbers
22257: WHERE inventory_item_id = l_item_id
22258: AND current_organization_id = l_org_id
23460: IF (Nvl(g_lpn_group_id,-999) <> l_lpn_grp_id) THEN
23461: g_lpn_group_id := l_lpn_grp_id;
23462: SELECT wms_epc_s2.NEXTVAL
23463: INTO g_epc_group_id
23464: FROM dual;
23465: END IF;
23466:
23467: IF (l_debug = 1) THEN
23468: print_debug('Calling populate_outside_epc',4);
23910: IF (Nvl(g_lpn_group_id,-999) <> l_lpn_grp_id) THEN
23911: g_lpn_group_id := l_lpn_grp_id;
23912: SELECT wms_epc_s2.NEXTVAL
23913: INTO g_epc_group_id
23914: FROM dual;
23915: END IF;
23916:
23917: IF (l_debug = 1) THEN
23918: print_debug('Calling populate_outside_epc',4);