APPS.RCV_ROI_TRANSACTION dependencies on DUAL

Line 6620: FROM DUAL

6616: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') <> 'DELIVER') THEN --{
6617: -- Bug 2551443 Removed po_distributions from the FROM clause
6618: SELECT COUNT(*)
6619: INTO x_temp_count
6620: FROM DUAL
6621: WHERE EXISTS(SELECT 1
6622: FROM po_line_locations pll,
6623: po_lines pl
6624: WHERE pl.po_line_id = temp_cascaded_table(current_n).po_line_id

Line 9172: from dual; -- Check whether this has to be unique */

9168: v_current_interface_id := v_trans_tab(j).interface_transaction_id;
9169: l_ls_table_idx := l_ls_table.COUNT + 1;
9170:
9171: /* SELECT GROUP_SEQUENCE_ID_S.nextval into V_TRANS_TAB(j).GROUP_ID
9172: from dual; -- Check whether this has to be unique */
9173: -- Will use the group_id from the header_record as the pre-processor
9174: -- needs the header and transactions group id to be the same
9175: IF (v_trans_tab(j).transaction_type IN('RECEIVE', 'SHIP')) THEN
9176: v_trans_tab(j).GROUP_ID := v_header_record.header_record.GROUP_ID;

Line 9221: FROM DUAL;

9217: AND v_trans_tab(j).lpn_group_id IS NULL
9218: ) THEN
9219: SELECT rcv_interface_groups_s.NEXTVAL
9220: INTO v_trans_tab(j).lpn_group_id
9221: FROM DUAL;
9222: END IF;
9223:
9224: IF (g_asn_debug = 'Y') THEN
9225: asn_debug.put_line('Inserting new RTI');

Line 9586: FROM DUAL;

9582: AND v_trans_tab(j).lpn_group_id IS NULL
9583: ) THEN
9584: SELECT rcv_interface_groups_s.CURRVAL
9585: INTO v_trans_tab(j).lpn_group_id
9586: FROM DUAL;
9587: END IF;
9588:
9589: IF (g_asn_debug = 'Y') THEN
9590: asn_debug.put_line('category_id ' || v_trans_tab(j).category_id);

Line 12504: --Bug 8631613 For some conversions residual qty. is causing issues while doing put away.

12500: temp_cascaded_table(current_n).po_line_location_id := x_po_transferrec.po_line_location_id;
12501: temp_cascaded_table(current_n).primary_unit_of_measure := x_po_transferrec.primary_unit_of_measure;
12502:
12503: IF (temp_cascaded_table(current_n).unit_of_measure <> x_po_transferrec.unit_of_meas) THEN
12504: --Bug 8631613 For some conversions residual qty. is causing issues while doing put away.
12505: l_temp_qty := convert_into_correct_qty(x_converted_parent_trx_qty,
12506: x_po_transferrec.unit_of_meas,
12507: temp_cascaded_table(current_n).item_id,
12508: temp_cascaded_table(current_n).unit_of_measure