APPS.INV_DETAIL_UTIL_PVT dependencies on DUAL

Line 2889: FROM dual;

2885: --
2886: -- get the next val of mtl_material_transactions_s
2887: FUNCTION next_temp_id RETURN NUMBER IS
2888: CURSOR l_cursor IS SELECT mtl_material_transactions_s.NEXTVAL
2889: FROM dual;
2890: l_temp_id NUMBER;
2891: BEGIN
2892: OPEN l_cursor;
2893: FETCH l_cursor INTO l_temp_id;

Line 3155: INTO l_txn_header_id FROM DUAL;

3151: -- l_qty_sign := -1;
3152: -- END IF;
3153: l_qty_sign := 1;
3154: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3155: INTO l_txn_header_id FROM DUAL;
3156: g_transaction_header_id := l_txn_header_id;
3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3158: INTO l_txn_temp_id FROM DUAL;
3159: IF p_request_context.item_lot_control_code = 2 THEN

Line 3158: INTO l_txn_temp_id FROM DUAL;

3154: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3155: INTO l_txn_header_id FROM DUAL;
3156: g_transaction_header_id := l_txn_header_id;
3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3158: INTO l_txn_temp_id FROM DUAL;
3159: IF p_request_context.item_lot_control_code = 2 THEN
3160: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3161: INTO l_serial_temp_id FROM DUAL;
3162: END IF;

Line 3161: INTO l_serial_temp_id FROM DUAL;

3157: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3158: INTO l_txn_temp_id FROM DUAL;
3159: IF p_request_context.item_lot_control_code = 2 THEN
3160: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3161: INTO l_serial_temp_id FROM DUAL;
3162: END IF;
3163: l_mmtt_tbl_size := 0;
3164: l_mtlt_tbl_size := 0;
3165: l_msnt_tbl_size := 0;

Line 3536: INTO l_serial_temp_id FROM DUAL;

3532: -- see whether we need a new l_serial_temp_id
3533: IF p_request_context.item_serial_control_code IN (2,5,6) THEN
3534: -- get the serial temp id if serial control is yes
3535: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3536: INTO l_serial_temp_id FROM DUAL;
3537: END IF;
3538: END IF;
3539: IF p_request_context.item_lot_control_code = 2 THEN
3540: -- lot control is yes

Line 3555: INTO l_txn_temp_id FROM DUAL;

3551: -- reset the quantity for the next mmtt record
3552: l_txn_temp_qty := 0;
3553: l_sec_txn_temp_qty := 0;
3554: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
3555: INTO l_txn_temp_id FROM DUAL;
3556: END IF;
3557: -- accumulate the quantity from g_output_process_tbl(l_index)
3558: -- for the next mmtt record
3559: l_txn_temp_qty := l_txn_temp_qty

Line 3910: SELECT 'Y' into l_status_return FROM DUAL WHERE EXISTS(

3906: -- Allocation is across loose and packed material.
3907:
3908: BEGIN
3909:
3910: SELECT 'Y' into l_status_return FROM DUAL WHERE EXISTS(
3911: SELECT 1 FROM mtl_onhand_quantities_detail moqd
3912: WHERE moqd.organization_id = p_organization_id
3913: AND moqd.inventory_item_id = p_inventory_item_id
3914: AND moqd.subinventory_code = p_subinventory_code